Date format that includes day of week


Posted by Mitchell Lewis on November 26, 2001 1:12 PM

Is there a date format that includes the day of the week?



Posted by Russell Hauf on November 26, 2001 1:24 PM

You will need to use a custom formula. Go to Format-Cells, and select Custom. Type in:

dddd, mm/dd/yyyy

This will give you Monday, 11/26/2001 (as long as you have today's date in that cell).

Hope this helps,

Russell