MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Day of the week

Posted by Mike on January 17, 2002 2:57 PM

Is there any way for excel to show the day of the week if you have a numerical date? i.e. 1/17/02 would show up as Thursday.

thanks in advance

Posted by Mark W. on January 17, 2002 2:59 PM

Format as dddd [nt]

Posted by Doug on January 17, 2002 2:59 PM

Insert the date into the cell. Then "Format-Cells". Under the "Number" tab click on "Custom". In "Type" put in 'ddddd'. That should display the day of the week.