ExcelBanter - Date format in Excel

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Date format in Excel (https://www.excelbanter.com/new-users-excel/162887-date-format-excel.html)

Carla

Date format in Excel

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?

Peo Sjoblom

Date format in Excel

format the cell as

dddd, mmm dd

dddd, mmm dd yyyy

--

Regards,

Peo Sjoblom

"Carla" wrote in message
...
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?

All times are GMT +1. The time now is 11:25 PM.