MrExcel Publishing
Your One Stop for Excel Tips & Solutions

weekday names


Posted by brian on November 01, 2001 6:34 AM

Can you have a date format as day of the week?

11/1/01 = Thursday

a simple method?


Posted by Chris on November 01, 2001 6:42 AM

Yes

select all cells with the dates in go to format cells then custom and in the dialog box type "dddd". This will format all dates to the day of the week.

Hope this is what you were after.

Chris

Posted by brian on November 01, 2001 6:46 AM

thanks

Posted by Jonathan on November 01, 2001 7:00 AM

Brian, let's say you have a date in A1, say, 11/01/2001. Then this, placed in another cell somewhere, will return 'Thursday':

=TEXT(WEEKDAY(INDIRECT("A1")),"dddd")

HTH

Posted by IML on November 01, 2001 9:13 AM

Also, =text(a1,"dddd") will work if you prefer formula to format(nt)