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