# 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
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

East 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

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.