Explanation
The DAY function returns the day component of a date.
The EOMONTH function returns the last day of the month for a given date.
Use a positive value for months to move forward in time, and a negative number…
Days in month
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))
