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


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