Monday, 20 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 !
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)