# Count number of dates in a column occuring in a specific month and specific year

1. ## Count number of dates in a column occuring in a specific month and specific year

Hello -

I have a spreadsheet with a date column that has about 10,000 dates (format dd/mm/yyyy) over the course of 3 years. I am looking for a formula that counts the number of entries by month/year (ie, the number of entries that fall in March, 2013.)

I have attached an example spreadsheet. The entries I need to count is in column N. You can see the table I developed and the formula I was trying to use:

=SUMPRODUCT(--(ISNUMBER(S\$2:\$S\$50)),(MONTH(\$S\$2:\$S\$50)=(MONTH(M53))))

2. ## Re: Count number of dates in a column occuring in a specific month and specific year

I think that Pivot Table would be the best solution for you.
use your column N as both row headers and data values. group row headers by months AND years.

Kopia Example BTS.xlsx

By the way - you have data in column N, while formula in your spreadsheet addresses data in column S - is there rationale behind it?

Best Regards

3. ## Re: Count number of dates in a column occuring in a specific month and specific year

Hi Kaper -

I did think about using a pivot table, but would also like to find a formula that does the same. Any thoughts?

There are currently 1 users browsing this thread. (0 members and 1 guests)