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


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.


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


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':



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

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