Counting Dates from certain months within certain cells

[Paul H]

Hi all,

I am struggling to find away of counting cells that contain certain dates.

Example...

Cells below have these dates in date format
a1 = 05/07/201
a6 = 16/08/2011
a8 = 27/09/2011
a10 = 13/07/2011
a12 = 24/07/2011
a27 = 22/08/2011

In cell a30 I am trying to count the number of times a July date is found in the above cells. Answer should be 3

In cell a31 I am trying to count the number of times an August date is found in the above cells. Answer should 2

In cell a32 I am trying to count the number of times an September date is found in the above cells. Answer should 1

I have tried using countif and sumproduct and countifs but can't seem to make them work.

P.S. I can't use a range of cells i.e. A2:A27 as some of the cells within this range I don;t want to include in the count even though they have a July, August or September date.

Any help would be greatly appreciated

Thanks you in advance

Paul

 

[Paul H]

Biff,

That is quite an improvement indeed!!! Sorry for the extra work you did having not show my exact requirements at the start.

I will have a proper look at your formula to try and understand how all the components work as this will be of great use in the future.

Cheers

Paul

 

[T. Valko]

Biff,

That is quite an improvement indeed!!! Sorry for the extra work you did having not show my exact requirements at the start.

I will have a proper look at your formula to try and understand how all the components work as this will be of great use in the future.

Cheers

Paul

You're welcome. Thanks for the feedback!