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.

Leave a comment

Please note: Use of a non-personal web site or blog in the field below and/or comments that are off-topic or personal attacks will likely be removed at my discretion.

Your comment