View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jennifer
 
Posts: n/a
Default 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!