Difference between two dates Excluding Sunday in SharePoint Calculated Column

This SharePoint tutorial, we will discuss the differences between two date Excluding Sunday in SharePoint by using calculated column.

First, we create the list with column name From Date and To Date.

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 Calculated Column

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 Calculated Column

You may like following SharePoint tutorials:

This SharePoint tutorial, we will discuss how to get the difference between two date Excluding Sunday in SharePoint Calculated Column.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

>