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

Office 365 public website – going down

I’ve blogged about the discontinuing of public websites a while back and I promised that I would write an update, when there was something to update on. And guess what! …

Read more

Formatting dates in Itemstyle.xsl

Insert this line at the top xmlns:ddwrt=”” 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