changing the DAY(NOW()) code to say "third" instead of 3

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have a spot on a contract that says "signed this _____
day of ______________, 2003". I can get it to put a 3 in
the first blank and August in the second by using the DAY
and MONTH functions with NOW() as an argument. I would
prefer to have it read "this third day of August instead
of this 3 day of August"
Can anyone help?
<}(:o)
David
 
Hi David,

Try this formula:

=CHOOSE(DAY(NOW())*(DAY(NOW())<21)+21*(DAY(NOW())>20)*(DAY(NOW())<30)+(DAY(N
OW())-8)*(DAY(NOW())>29),"first","second","third","fourth","fifth","sixth","
seventh","eighth","nineth","tenth","eleventh","twelfth","thirteenth","fourte
enth","fifteenth","sixteenth","seventeenth","eighteenth","nineteenth","twent
ieth","twenty-"&CHOOSE(DAY(NOW())-20,"first","second","third","fourth","fift
h","sixth","seventh","eighth","ninth"),"thirtieth","thirty-first")


HTH
 
Back
Top