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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
One way:
=DAY(DATE(YEAR("1-"&A1&"-"&B1),MONTH("1-"&A1&"-"&B1)+1,0))
 
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:
 
Do you have your machine set up to expect a semi-colon (rather than a comma)
as a list separator?
 
Thanks a bunch!
How stupid of me.. Now I'm getting it right.

"David Biddulph" kirjoitti:
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find out specific month and year 1
Days in a month as of today 2
Access Count dates within a Month 4
Generating date from day, month year 4
Count the number of workday in a month 5
First Day of the month 3
YEAR MONTH DAYS COUNTER 6
Days Count Sheet Help 5

Back
Top