Excel Forum
Similar Content
Years, Months, Days Between two dates in Excel
Tutorial: I have found a rather convoluted method to Calculate the Number of Years, Months and Days ...
6 Tricks to Make Dates Work in Excel
Tutorial: Watch this tutorial if you work with dates! Quick and easy ways to reliably convert dates...
How to Use Dates in Excel
Tutorial: Introduction Guide to using Dates in Excel - this tutorial will show you how to input and...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.