Home > Uncategorized > Excel – Number of days in a given month

Excel – Number of days in a given month

February 15th, 2015 Leave a comment Go to 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.

  1. No comments yet.
  1. No trackbacks yet.