Main Profile

At A Glance

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.
Length: 04:36

Contact

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.

  • Answer

Ask a New Question