DateDif in SharePoint

The function for calculating the difference between two dates in a calculated column in SharePoint, without counting the weekends: =(DATEDIF([Start Date];[End Date];”D”))-INT(DATEDIF([Start Date];[End Date];”D”)/7)*2-IF((WEEKDAY([End Date])-WEEKDAY([Start Date]))<0;2;0)+1

Formatting dates in Itemstyle.xsl

Insert this line at the top xmlns:ddwrt=”http://schemas.microsoft.com/WebParts/v2/DataView/runtime” That will give you a header looking like this: Then use the “ddwrt:FormatDate” to show the date i various ways: <xsl:value-of select=”ddwrt:FormatDate(@dato, 1030, …

Read more