# Excel question - COUNTIF by month?

**URL:** <https://boards.straightdope.com/t/excel-question-countif-by-month/599415>\
**Category:** Factual Questions\
**Created:** [October 12, 2011, 11:32am UTC](https://boards.straightdope.com/t/excel-question-countif-by-month/599415 "2011-10-12T11:32:25Z")\
**Posts on this page:** 1\
**Page:** 3

<div class="post-metadata">

**Author:** ![michany17](https://avatars.discourse-cdn.com/v4/letter/m/ba9def/32.png) [@michany17](https://boards.straightdope.com/u/michany17)\
**Post date:** [March 25, 2016, 1:35pm UTC](https://boards.straightdope.com/t/excel-question-countif-by-month/599415/41 "2016-03-25T13:35:57Z")

</div>

Thanks for the response, Cooking with Gas. Yes, unfortunately, I did try all of the suggestions, to no avail, for a range crossing over columns and rows. I did get most of them to work for individual columns, but not multiple columns without doing the formulas for each column.

The dates are entered into a software database, pulled into a report, then dumped into Excel. The dates are entered through a date picker and display as mm/dd/yyyy. (I’ve tried changing them into multiple formats, but that didn’t help either.) They will be in no particular order. What I need Excel to do is take all of the dates, in say a 100 row by 100 column spreadsheet, which will vary month to month, and calculate how many dates are for a particular month. Does that make sense?

[Previous page](https://boards.straightdope.com/t/excel-question-countif-by-month/599415.md?page=2)