Custom dates

A

Aardvark

Hi all,

Can anyone tell me how to format dates thus:- Saturday 9th May?

Thanks,

Danny
 
D

Don Guillett

use this if you don't need the th.
=TEXT(A9,"ddd, d mmmm")
or this if you do. You will notice if didn't finish the ifs
=TEXT(A9,"ddd, d")&IF(DAY(A9)=1,"st ",IF(DAY(A9)=2,"nd ","th
"))&TEXT(A9,"mmmm")
 
E

Earl Kiosterud

Aardvark,

Can't be done. At least not in my time zone. May 9 is Sunday. That aside,
you can use the following custom format code on a regular date cell
(Format - Cells - Number - Custom)

dddd mmm d, yyyy
 
D

Don Guillett

I'm sorry RD but my finger got tired. Let's just use the whole name.
if 3 then Raydyer, th
 
A

Aardvark

Au Contraire, May the 9th is only a Sunday THIS year :)

Thank you for your help guys and gals
 
Top