MrExcel Consulting
Your One Stop for Excel Tips & Solutions

Day and date

Posted by ~Rob on August 16, 2001 8:58 AM

I have a column of dates and I would like to have the corresponding day of the week next to it. It does not matter if it is in the same column or in it's own column. Any Ideas?

Thanks, ~Rob

Posted by Skip Bisconer on August 16, 2001 9:06 AM

Try this Assuming your date is in column A
=WEEKDAY(A3) this is from the Excels function selection in Date & Time

Posted by Barrie Davidson on August 16, 2001 9:07 AM

Try =A1 and then custom format that cell to "dddd"


Posted by neo on August 16, 2001 9:08 AM

right-click the cells that have the dates in it, select 'format cells' and under the number tab choose 'custom'. in the box where the format goes type: mm/dd/yyyy dddd

and your dates should look like: 09/16/2001 Thursday