ExcelBanter - How to show the day of the week

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

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

- - How to show the day of the week (https://www.excelbanter.com/excel-discussion-misc-queries/170791-how-show-day-week.html)

sjames

How to show the day of the week

How can I format my dates 12/01/2007 to equal the day of the week?

Bob Phillips

How to show the day of the week

Use a format of "dddd dd/mm/yyyy" without the quotes

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"sjames" wrote in message
...
How can I format my dates 12/01/2007 to equal the day of the week?

All times are GMT +1. The time now is 01:30 AM.