MrExcel Publishing
Your One Stop for Excel Tips & Solutions


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:


Posted by Jo on January 21, 2002 8:24 AM

THANK YOU!! That worked great!!!