Count if with dates

Dear Experts:

I got thousand of sorted dates in Column A (in German Format dd.mm.yyyy).

- Column A is sorted, starting from 01.01.2014 and ending at 31.12.2014.
- There are multiple occurrences of dates, i.e. 07.05.2014 can occur e.g. 20 times.

I would like to be able to count the number of dates ...
... that fall within a specific month (e.g. june 2014 or october 2014) without manually selecting the range and employ the count function.

This operation should be done by using a function, such as count if. I am somehow not able to use this function in this case

I have attached a sample file for your convenience.

Help is much appreciated. Thank you very much in advance.

Regards, Andreas

COUNT-IF-Dates-Range.xlsx
Andreas HermleTeam leaderAsked:
Who is Participating?
 
Anne TroyEast Coast ManagerCommented:
=SUM(IF(MONTH(A2:A6)=1,1))  for January

=SUM(IF(MONTH(A2:A6)=2,1))  for February

=SUM(IF(MONTH(A2:A6)=3,1))  for March

or change the 1, 2, 3 digit to a cell reference that contains that number or a date within the range.

These are CSE. You must enter the formula, then Ctrl+Shift+Enter
0
 
Andreas HermleTeam leaderAuthor Commented:
Hi Dreamboat,

great, works like a charm, thank you very much for your great and swift help.

Regards, Andreas
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.