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.
Questions about Excel Magic Trick #220: Count Dates In Each Month
Want more info about Excel Magic Trick #220: Count Dates In Each Month?
Get free advice from education experts and Noodle community members.