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

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!

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!

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

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:
=DAY(DATE(YEAR("1-"&A1&"-"&B1),MONTH("1-"&A1&"-"&B1)+1,0))
--

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

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

"Tumar" wrote in message
...
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:
=DAY(DATE(YEAR("1-"&A1&"-"&B1),MONTH("1-"&A1&"-"&B1)+1,0))
--

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

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

"David Biddulph" kirjoitti:

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

"Tumar" wrote in message
...
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:
=DAY(DATE(YEAR("1-"&A1&"-"&B1),MONTH("1-"&A1&"-"&B1)+1,0))
--

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

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

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!