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
3. Now you Select the date and see the Number of days excluding Sunday and To Date. See in fig