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

[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

 

[Andy Brown]

A few formula variations here -

http://www.google.co.uk/groups?hl=e...ie=UTF-8&oe=UTF-8&as_ugroup=*excel*&lr=&hl=en

but they'll give you "3rd" not "third".

You could use VLOOKUP and a 2-column table -- 1st column = 1 - 31, 2nd
column = "first", "second", etc.

But this really sounds like a job for Word.

Rgds,
Andy

 

[Orlando Magalhães Filho]

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