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

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