Number of days in month counted from shortened name of month & yea
On Tue, 18 Sep 2007 00:12:00 -0700, 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!
=DAY(--(A1&A2)+32-DAY(--(A1&A2)+32))
should do what you want.
--ron
|