Custom dates

  • Thread starter Thread starter Aardvark
  • Start date Start date
A

Aardvark

Hi all,

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

Thanks,

Danny
 
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")
 
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
 
I'm sorry RD but my finger got tired. Let's just use the whole name.
if 3 then Raydyer, th
 
Au Contraire, May the 9th is only a Sunday THIS year :-)

Thank you for your help guys and gals
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Sheet Names and Date cells 3
matching a customer with a twist.. 1
Excluding Friday & Saturday from the calculation 1
Get Number of Date between two date but not include Saturday/Sunday 1
Help with IF 2
work with IF 3
week numbers 3
How do I auto fill a date series 2

Back
Top