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


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.