A
Aardvark
Hi all,
Can anyone tell me how to format dates thus:- Saturday 9th May?
Thanks,
Danny
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")
=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
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
R
Ragdyer
I'm hurt Don, you forgot my initials<g>.
D
Don Guillett
I'm sorry RD but my finger got tired. Let's just use the whole name.
if 3 then Raydyer, th
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
Thank you for your help guys and gals