Days in month

An excel formula to days in month

Related Functions

Sponsored Link

 Days in month
=DAY(EOMONTH(date,0))

To get the number of days in a given month from a date, you can use a formula based on the EOMONTH and DAY functions.

In the example shown, the formula in cell B5 is:

 
=DAY(EOMONTH(B5,0))

How this formula works

The DAY function returns the day component of a date.  The EOMONTH function returns the last day of the month for a given date. So, in this formula EOMONTH first returns a date corresponding to the last day of the month, and then DAY returns the date value for that date.

By definition, the value returned by DAY is always equal to the number of days in the month, since the date supplied to DAY is always the last day.

Sponsored Link

0 votes. 0 / 5