Difference between two date Excluding Sunday in SharePoint Server 2010


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 dates 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 dates Excluding Sunday in SharePoint Server 2013
Check out Best Alternative to InfoPath -> Try Now

FREE SHAREPOINT 2019 PDF


New to Office 365 SharePoint Online? Get Office 365 Enterprise E3 Subscription & Try out all the features

(Installation & Features)



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 →