Date Format

macrogeek

New Member
Joined
Nov 24, 2005
Messages
4
Hi all, this is my first post :)

Please can anyone tell me how to format a date so that the following is displayed

Wednesday 21st November 2005

I can use dddd dd mmmm yyyy but it does not give the st. I would like it to show th / rd / st /nd etc.

Any ideas greatly received.
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,118,018
Messages
5,569,646
Members
412,285
Latest member
Daibear
Top