View Single Post
  #1   Report Post  
RawSugar
 
Posts: n/a
Default count no. of dates in a column that falls on certain month & year

based on the subject, i have a column that contains text and dates. i need to
count how many items fall on a certain month in a certain year. all dates are
not stored as text values and the column contains blank cells too. for
example:

Colum D
10/05/05
10/06/05
11/01/05
10/05/04
(blank cell)
11/10/05

i need the output to look like this:
Month:Oct Year:2004 = 1
Month:Nov Year:2004 = 0
Month:Oct Year:2005 = 2
Month:Nov YEar:2005 = 2

help on this will greatly be appreciated! thanks in advance!