| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date format with day of week and date
I have Excel 2003 and want to figure out how to format a cell where the date
and day of week appear...i.e. Wed 10/19/2005 I know how to make the date formats change but cannot find one that offers both the date as well as the day of week...if there are no options for it, what is the format for customizing it to do this? Thanks! Kathy |
|
#2
|
|||
|
|||
|
Date format with day of week and date
One way is to use a custom format
DDDD M/DD/YYYY "Kathy" wrote: I have Excel 2003 and want to figure out how to format a cell where the date and day of week appear...i.e. Wed 10/19/2005 I know how to make the date formats change but cannot find one that offers both the date as well as the day of week...if there are no options for it, what is the format for customizing it to do this? Thanks! Kathy |
|
#3
|
|||
|
|||
|
Date format with day of week and date
OR
DDD M/DD/YYYY to abbreviate Wed. "Kathy" wrote: I have Excel 2003 and want to figure out how to format a cell where the date and day of week appear...i.e. Wed 10/19/2005 I know how to make the date formats change but cannot find one that offers both the date as well as the day of week...if there are no options for it, what is the format for customizing it to do this? Thanks! Kathy |
|
#4
|
|||
|
|||
|
Date format with day of week and date
Thanks a lot!
"JMB" wrote: OR DDD M/DD/YYYY to abbreviate Wed. "Kathy" wrote: I have Excel 2003 and want to figure out how to format a cell where the date and day of week appear...i.e. Wed 10/19/2005 I know how to make the date formats change but cannot find one that offers both the date as well as the day of week...if there are no options for it, what is the format for customizing it to do this? Thanks! Kathy |
|
#5
|
|||
|
|||
|
Date format with day of week and date
You're welcome.
"Kathy" wrote: Thanks a lot! "JMB" wrote: OR DDD M/DD/YYYY to abbreviate Wed. "Kathy" wrote: I have Excel 2003 and want to figure out how to format a cell where the date and day of week appear...i.e. Wed 10/19/2005 I know how to make the date formats change but cannot find one that offers both the date as well as the day of week...if there are no options for it, what is the format for customizing it to do this? Thanks! Kathy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
| 52 week average based on date | Excel Discussion (Misc queries) | |||
| Format an excel column as a date for a 5 day week for a year. | Excel Discussion (Misc queries) | |||
| Custom Date format ie. 01.01.05 W1 (W1 is week 1) | Excel Discussion (Misc queries) | |||
Linear Mode
