On this [Nth] day of [Month] [Year]

[Krhea]

Hey everyone,

I have been using a simple if function to make this work for documents using code like:
=IF(AG28="",IF(MONTH(TODAY())=1,"January",IF(MONTH(TODAY())=2,"February",IF(MONTH(TODAY())=3,"March",IF(MONTH(TODAY())=4,"April",IF(MONTH(TODAY())=5,"May",IF(MONTH(TODAY())=6,"June",IF(MONTH(TODAY())=7,"July",IF(MONTH(TODAY())=8,"August",IF(MONTH(TODAY())=9,"September",IF(MONTH(TODAY())=10,"October",IF(MONTH(TODAY())=11,"November","December"))))))))))),"")
and:
=IF(AG28="",IF(OR(DAY(TODAY())=1,DAY(TODAY())=21,DAY(TODAY())=31),"st",IF(OR(DAY(TODAY())=2,DAY(TODAY())=22),"nd",IF(OR(DAY(TODAY())=3,DAY(TODAY())=23),"rd","th"))),"")

My code works but it is sloppy, does anyone know of a macro to take a date and return that date in the form of:
On this [Nth] day of [month] [year]

Thanks in advance!

[mehmetcik]

Sorry got to go.

Here is a start for you.

the rest is easy.

=CHOOSE(Day(AG28),"First"," Second"," Third"," Fourth"," Fifth"," Sixth"," Seventh"," Eighth"," Ninth"," Tenth"," Eleventh"," Twelfth"," Thirteenth"," Fourteenth"," Fifteenth"," Sixteenth"," Seventeenth"," Eighteenth"," Ninteenth"," Twentieth"," Twenty First"," Twenty Second"," Twenty Third"," Twenty Fourth"," Twenty Fifth"," Twenty Sixth"," Twenty Seventh"," Twenty Eighth"," Twenty Nineth"," Thirtieth"," Thirty First")

[Krhea]

I've never used the CHOOSE Function, but I see how it works.

That's awesome! Thank you

[Richard Buttrey]

..and another option

Please Login or Register  to view this content.