Re: Formula For Number Of Days In A Month
Hi Robert
Something like this will work:
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))
Richard
Re: Formula For Number Of Days In A Month
That IS cool! Never saw that remark on the Help for the DATE function before.
Re: Formula For Number Of Days In A Month
=day(eomonth(a1,0))
Re: Formula For Number Of Days In A Month
even cooler...bravo!
Re: Formula For Number Of Days In A Month
Here's another way
=42-DAY(A1-DAY(A1)+42)
42 can actually be replaced with any number between 32 and 59.....as long as you use the same number twice
Re: Formula For Number Of Days In A Month
Quote from daddylonglegsHere's another way
=42-DAY(A1-DAY(A1)+42)
42 can actually be replaced with any number between 32 and 57.....as long as you use the same number twice
Smartass 
Re: Formula For Number Of Days In A Month
Quote from RichardSchollarSmartass
Hello Rich, I'm torn between "It takes one to know one" and "It's better to be a Smartass than a Dumbass!" :duck:
Re: Formula For Number Of Days In A Month
Quote"It's better to be a Smartass than a Dumbass!"
I'd rather just be an "ass" or arse
Don’t have an account yet? Register yourself now and be a part of our community!
