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
Hi
To do this:
In A1 you have the date
in B1 you have this: = text(A1,"DDDD")
Thats all there is to it.
Jacob
