Difference between two date Excluding Sunday in SharePoint Server 2010

InfoPath alternatives for form designing SharePoint
In this post we will discuss differences between two date Excluding Sunday in SharePoint Server 2010.
Also you can check out:
1. First we create the list with column name From Date and To Date.
2. Now we create the third column Number of Days with type of Calculated for storing the total date between two dates and enter the following formula. See in fig
(DATEDIF([From Date],[To Date],”D”))-INT(DATEDIF([From Date],[To Date],”D”)/7)*1-IF((WEEKDAY([To Date])-WEEKDAY([From Date]))<0,1,0)+1
Difference between two date Excluding Sunday in SharePoint Server 2010
Difference between two date Excluding Sunday in SharePoint Server 2010
3. Now you Select the date and see the Number of days excluding Sunday and To Date. See in fig
Difference between two date Excluding Sunday in SharePoint Server 2013
Difference between two date Excluding Sunday in SharePoint Server 2013

Similar SharePoint 2013 Tutorials


About Navneet Singh

I am Navneet Singh, Working at C3it software solutions pvt. ltd. in Pune. My core skills are SharePoint 2013, Office 365, SharePoint 2010, SharePoint Designer, SharePoint Designer Workflow, Nintex Workflow, Infopath, Webpart, CSOM/SSOM, Power-shell, C#, ASP.NET and SQL Server.

View all posts by Navneet Singh →

Leave a Reply