Archive

Archive for February, 2015

Excel – Number of days in a given month

February 15th, 2015 No comments

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.