Blog Archive

Excel: Calculate The Number Of Days In A Month

Category: Formulas | [Item URL]

Excel lacks a function for calculating the number of days in a particular month, so you'll need to construct your own formula.
If cell A1 contains a date, this formula will return the number of days in the month:
=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)

Post a Comment