Number of days in month counted from shortened name of month & yea
One way:
=DAY(DATE(YEAR("1-"&A1&"-"&B1),MONTH("1-"&A1&"-"&B1)+1,0))
--
David Biddulph
"Tumar" wrote in message
...
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!
|