Hi Peter,

This will get it for you

=DAY(DATE(YEAR(TODAY()),VLOOKUP(LEFT(A1,3),{"Jan", 2;"Feb",3;"Mar",4;"Apr",5;
"May",6;"Jun",7;"Jul",8;"Aug",9;"Sep",10;"Oct",11; "Nov",12;"Dec",13},2,FALSE
),0))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Bigpond News" wrote in message
...


Can anyone tell me how to put more than 9 if statements into a single
formula ? I can get 9 om a row but not 9
for instance if i want to detect the numbers of days in a mont on a large
spreadsheet I may enter
=if(a1="Jan",31,if(a1="Feb",28,if(a1="Mar",31,0))) and so on, I can get it
to work upto September with it working then it comes up with an error,

PS sorry also posted this on Excel worksheet functions page by mistake
Thank


Peter