Showing posts with label Tip. Show all posts
Showing posts with label Tip. Show all posts

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 !