Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

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

Re: Day and date

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

Re: Day and date

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

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


Re: Day and date

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


This archive is from the original message board at
All contents © 1998-2004
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.