Date format in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carla - 20 Oct 2007 04:10 GMT

Hi,

I would like to be able to enter a date in the following format:
10/19/07
and have it show up in the column as:
Friday, Oct 19 or Friday, Oct 19, 2007. Important part is getting the
appropriate day of the week in there.

Is this possible?

Reply to this Message

Peo Sjoblom - 20 Oct 2007 04:16 GMT

format the cell as

dddd, mmm dd

dddd, mmm dd yyyy

Signature

Regards,

Peo Sjoblom

> Hi,
>
[quoted text clipped - 5 lines]
>
> Is this possible?

Reply to this Message