Sharepoint calculated column more date / day calculations

By peter.stilgoe

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

About... peter.stilgoe

This author published 368 posts in this site.
Sharepoint, InfoPath, K2, Nintex, Business Process Mapping, Business Intelligence, Automation, ECM, Document Management, Document Imaging, Internet Marketing & Online Business Consultant Email / MSN: pstilgoe@hotmail.com LinkedIn: Pete Stilgoe - Sharepoint Consultant