Dates
Posted by jo on January 21, 2002 7:44 AM
I have a report that shows the date of hours I'm inputting. (Past dates) I want to have a formula next to this date showing what day of the week it is I am inputting the hours for.
The cell for the date of report is in S & T 2 (Merged cells). the Cell I want the day is in Q & R 2 (Merged also).
Posted by Aladin Akyurek on January 21, 2002 7:52 AM
=TEXT(S2,"dddd") [NT]
Posted by Shams on January 21, 2002 7:55 AM
Try the following:
=Text(T2,"dddd")
Posted by Jo on January 21, 2002 8:24 AM
THANK YOU!! That worked great!!!
