MrExcel Publishing
Your One Stop for Excel Tips & Solutions

days of the week

Posted by Rob on December 27, 2001 1:33 PM

is it possible to enter a date field in a cell and have the cell beneath it reflect the correct day of the week for that date? Example: 1/1/02 is in A1, and below it I want the word Tuesday to appear. A2 would show 1/2/02 and B2 would show Wednesday. I know this could be done manually, but is there a formula that would automate the process? Thank you so much!

Posted by Jacob on December 27, 2001 1:38 PM


To do this:

In A1 you have the date
in B1 you have this: = text(A1,"DDDD")

Thats all there is to it.