Try this formula:

=DAY(EOMONTH(A1&A2,0))


"Tumar" wrote:

I'd need to get the number of days in a month from the shortened name of
month and a year.
I have for example JAN in cell A1, and 2007 in cell A2, and I would need to
get the 31 as a result.

Any suggestions?

Thanks in advance!