Date format with day of week and date

[Kathy]

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

[JMB]

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

[JMB]

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

[Kathy]

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

[JMB]

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