Formula for Calculating Day of Week in MS Office

This formula applies to SharePoint 2007 too. Remember to replace [DATE] below with your date point of reference. Also note that this formula applies to locales where Sunday is considered to be the first day of the week.

=CHOOSE(MOD([Date],7),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")