ExcelBanter - Applying days of the week to dates

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Applying days of the week to dates (https://www.excelbanter.com/excel-discussion-misc-queries/58744-applying-days-week-dates.html)

will

Applying days of the week to dates

Hi,

Does anyone know how to make Excel show the day of the week (ie Monday,
Tuesday etc.) given a specific date?

Thanks,

Will

Niek Otten

Applying days of the week to dates

Just format the cell Custom, "dddd"

--
Kind regards,

Niek Otten

"will" wrote in message
...
Hi,

Does anyone know how to make Excel show the day of the week (ie Monday,
Tuesday etc.) given a specific date?

Thanks,

Will

All times are GMT +1. The time now is 12:41 PM.