Tip Printed from ExcelTip.com

---

Finding the Number of Days in a Given Month


Problem:

Calculating the number of days in each of the months listed in column A, for the year specified in column B.

Solution:

Use the DAY and DATE functions as shown in the following formula:
=DAY(DATE(B2,A2+1,0))