Excel – Number of days in a given month
If you need to calculate the number of days in a given month, then assuming your date is in cell A1, then
=DAY(DATE(YEAR(A1),MONTH(A1)+1,))
will give you this. This basically works by calculating the day part of the zeroth day of the following month which means the last day of the month.