It seems Excel still can’t tell me the days in a particular month.

The following formula works, though:

=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)

Obviously, A1 has to have a date in it.

Works like a charm:

Update, much, much later: Looks like LibreOffice has a DAYSINMONTH function.

### Like this:

Like Loading...

*Related*

thank you.:)

how do we get for previous month is there

any formula for that

@Nishant ..did u get the solution..pls post,if yes

Thanks the formula works

If possible I want to get result by giving name of month like “January”, “February” etc. instead of given date in cell A1. Is it possible? if yes, anybody please help me soon @ nishantverma8391@gmail.com

Thanks A lot

thank you michael..

thanks a lot……perfect formula to get a number of days in a month…..

Thanks a lot

Hey Linto,

There seems to be no "get previous month" function in OpenOffice (and I don't have MS Office installed right now), so I came up with this formula which seems to work:

=DATE(YEAR(a1);MONTH(a1)-1;1)

It gives you the first day of the previous month of a date in field a1. To get the length of that previous month, just use the same formulas from this post on the date you have thus obtained.

THANKS MICKY BRO

THANKSSSSSSSSSSSSSSSSSSSSS

Saiful, that's simply a matter of assigning the cell a custom date format, I'd say.

I want to get result by giving name of month like "January", "February" etc. instead of given date in cell B3. Is it possible? if yes, anybody please help me soon. Thanks

Awesome, one click answer, thanks.

Now, can we calculate just the weekdays in a month with a similar method?

Thanks Mr. Nils & Mr.Micky

Thanks Micky!!!!

Thanks Micky!

EOMONTH may not always be available it seems: http://office.microsoft.com/en-001/excel-help/eomonth-HP005209076.aspx – so if anybody can't use Micky's cool shorter version, the original formula should still do the trick 🙂

No need or such a "long" formula.

In B2 type: =DAY(EOMONTH(B3,0))

Michael Avidan

“Microsoft®” MVP – Excel

ISRAEL

Really excellent. Thanks.