Metacafe Header Takeover  

Excel Magic Trick #220: Count Dates In Each Month

Tags:
Colleges Community Count Dates Eomonth Excel Formula Function Gel Girvin Highline In Mike Months Sumproduct
ExcelIsFun
  • Affiliate Submitter:
    ExcelIsFun
  • International International
  • Comments: 0
  • Views: 188
  • Added: 21-Jan-09

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.

  1. Categories: Science & Tech
Comments on

Excel Magic Trick #220: Count Dates In Each Month

4 Comments | Add Comment
  • Dear ChicagoBears1, ...

    Dear ChicagoBears1,

    Happy Excelling in Chicago!

    --excelisfun

    By ExcelIsFun [Affiliate User] 1232736902 Reply Spam Moderate Up Moderate Down
  • I do not live in ...

    I do not live in the city, rather, a Northwest suburb. IMHO, city life is cool for my single friends, but my kids need room to run around. Big summer parties, you know how it goes.

    By ChicagoBears1 [Affiliate User] 1232725948 Reply Spam Moderate Up Moderate Down
  • Dear ChicagoBears1, ...

    Dear ChicagoBears1,

    I am glad that the videos and workbooks are useful!

    Do you live in Chicago? I lived in Chicago during the Ditka years - boy was that a fun time to be a Bears fan in Chicago (I also lived just a few blocks from Wrigley Field - that - was fun too).

    --excelisfun

    By ExcelIsFun [Affiliate User] 1232720710 Reply Spam Moderate Up Moderate Down
  • Your tutorials are ...

    Your tutorials are great man. I've downloaded a couple of your spreadsheets for personal finances, etc. Great stuff!

    By ChicagoBears1 [Affiliate User] 1232719535 Reply Spam Moderate Up Moderate Down
4 Comments | Add Comment