View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cody
 
Posts: n/a
Default Counting Dates #2

What formula to read a range of cells with a lot of dates in it and than
count how many times the current month shows up in it (has to recognize the
year too because if it only counts all dates with November in them it cant
count 2003, 2004 etc.. only the current month)

Example:

11/4/2005
11/9/2003
11/12/2005
12/1/2005

This would need to give me a total of: 2

Thank you,
--
na