Sharepoint calculated column more date / day calculations

Published on

Avoiding Saturday & Sundays if you were sending out alerts for example: =IF([Call due day]=”Saturday”,[Call due date]+2,IF([Call due day]=”Sunday”,[Call due date]+2,[Call due date]) Displaying the day as text: =TEXT(WEEKDAY([Due Date]),”dddd”) Say you have a date in US format and you want to convert it to UK format: =TEXT([Your Date Field],”DD-MM-YYYY”)

Sharepoint Calculated Column – Tasks Due This Week

Published on

To show tasks due this week, create the following 2 calculated columns: Week start (Monday) =[due date]-(WEEKDAY([due date],2)-1) Week end (Friday) =[due date]+(5–WEEKDAY([due date],2)) Create a view where: Week start is less than or equal to [Today] AND Week end is greater than or equal to [Today] More useful scenarios here: http://www.myriadtech.com.au/blog/Alana/Lists/Posts/Post.aspx?ID=8

Sharepoint Common Date Formulas For Calculated Columns

Published on

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 given date: =[End Date]+7-WEEKDAY([End Date]) First day of the month for a given date: =DATEVALUE(”1/”&MONTH([Start Date])&”/”&YEAR([Start Date])) Last day of the month for a given … Continue reading Sharepoint Common Date Formulas For Calculated Columns