Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
Day and datePosted 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?
Re: Day and datePosted 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 datePosted by Barrie Davidson on August 16, 2001 9:07 AM
Try =A1 and then custom format that cell to "dddd"
Re: Day and datePosted 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 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.