Tuesday, 21 February 2012

Excel: Date to DOTW

Here is a quick tip / reference to how to calculate the day of the week from a date.

=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

A handy tip !

No comments:

Post a Comment