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”)

More From pstilgoe

• Displaying the week number using a Sharepoint calculated column
• Calculated column – some restrictions
• Sharepoint Calculated Column – Tasks Due This Week

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

More From pstilgoe

• Displaying the week number using a Sharepoint calculated column
• Sharepoint calculated column more date / day calculations
• Calculated column – some restrictions

Create & calculated column and add the following formula:

=INT(([Start Date]-DATE(YEAR([Start Date]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Start Date]),1,1)),”d”)))/7)+1

More From pstilgoe

• Sharepoint calculated column more date / day calculations
• Calculated column – some restrictions
• Sharepoint Calculated Column – Tasks Due This Week

- You cannot reference a value in a row other than the current row (as opposed to Excel).

- You cannot reference a value in another list or library.
- You cannot reference lookup fields in a formula.

- You cannot reference the ID of a row for a newly inserted row. The ID does not yet exist when the calculation is performed.

More From pstilgoe

• Displaying the week number using a Sharepoint calculated column
• Sharepoint calculated column more date / day calculations
• Sharepoint Calculated Column – Tasks Due This Week

You probably think this is going to be quite long winded & involve many IF statements, its actually pretty simple as I just found out.

Create a ‘Calculated Column’ & for your formula add:

=TEXT([YourDateField],”mmmm”)

More From pstilgoe

• Displaying the week number using a Sharepoint calculated column
• Calculated column – some restrictions
• Sharepoint calculated column more date / day calculations