Secret Diary of a PM
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment