Excel Forum

Excel Magic Trick #220: Count Dates In Each Month

From a List of dates, see how to create a formula with the SUMPRODUCT and EOMONTH functions that count the dates in each month. Also see a formula that will work in earlier versions of Excel using the functions: SUMPRODUCT, DATE, YEAR, MONTH.
Formula for Excel 2007 or Excel 2003.

Got a Question? Ask it Here in the Forum.