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"

Barrie


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

neo


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
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.