Category Archives: Sharepoint 2010 OutOfTheBox

Common Date Time formulas for Sharepoint – Calculated Fields Get Week of the year =DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time]))+0.5-WEEKDAY(DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time])),2)+1 First day of the week for a given date: =[Start Date]-WEEKDAY([Start Date])+1 Last day of the week for a … Continue reading →