Days in a Month
How to Calculate the Number of Days in a Month Using Excel Formula

Learn the simple Excel formula =DAY(EOMONTH(A1,0)) to return the number of days in any month based on a given date.