« Full body PET CT | Main | Fun with Google Maps - TT »

Excel Tip Day of Week

Every body asks us for help on complicated Excel problems. Here is a great tool for labeling the date information.

In Cell A1 put
=TEXT(WEEKDAY(B1), "ddd")
In cell B1 put a date (ie 11-01-2005)

This will display the day of week for you as the following.

d: Numeric value (1,2,3 ... 7)
dd: Numeric with leading zero (01,02,03 ... 07)
ddd: Three letter Day (Sun, Mon, Tue .... Sat)
dddd: Full Day Name (Sunday, Monday ..... Saturday)

Posted by mkn on November 1, 2005 9:06 PM |

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)