Number of days in month counted from shortened name of month & yea

T

Tumar

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!
 
T

Tumar

Thanks for the quick answer!

I still get the " Formula you typed contains an error"-message
I did try something similar yesterday, but every time I seem to get this
error message referring to ,MONTH part of the formula.

Any idea why this is & what would help?

"> One way:
 
D

David Biddulph

Do you have your machine set up to expect a semi-colon (rather than a comma)
as a list separator?
 
T

Tumar

Thanks a bunch!
How stupid of me.. Now I'm getting it right.

"David Biddulph" kirjoitti:
 
R

Ron Rosenfeld

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!
Click to expand...

=DAY(--(A1&A2)+32-DAY(--(A1&A2)+32))

should do what you want.
--ron
 
Top