Counting distinct entries based on meeting month & year criteria
 

Hi - please help!

In column A, I have the following entries:
01/05/04
01/10/04
01/01/05
01/15/05
01/20/05
01/30/05
02/08/04
02/13/05
02/20/05
02/21/05

How can I 'count' the number of dates that are in January 2004, January 2005
etc?
Specifically:
For January 2004 date count in cell B1 = 2
For January 2005 date count in cell B1 = 4
For February 2004 date count in cell B1 = 1
For February 2005 date count in cell B1 = 3

Thank you!

Counting distinct entries based on meeting month & year criteria
 

Try in B1 for January 2004.

=SUMPRODUCT((YEAR(A1:A10)=2004)*(MONTH(A1:A10)=1))

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=510290

Counting distinct entries based on meeting month & year criteria
 

Correction to the end results below

"jennifer" wrote:
Hi - please help!

In column A, I have the following entries:
01/05/04
01/10/04
01/01/05
01/15/05
01/20/05
01/30/05
02/08/04
02/13/05
02/20/05
02/21/05

How can I 'count' the number of dates that are in January 2004, January 2005
etc?

Specifically:
For January 2004 date count in cell B1 = 2
For January 2005 date count in cell B2 = 4
For February 2004 date count in cell B3 = 1
For February 2005 date count in cell B4 = 3

Thank you!

Counting distinct entries based on meeting month & year criter
 

Thanks Steve...worked like a charm!

"SteveG" wrote:


Try in B1 for January 2004.

=SUMPRODUCT((YEAR(A1:A10)=2004)*(MONTH(A1:A10)=1))

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=510290