View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lori
 
Posts: n/a
Default Count According to Date

I need a formula that will count the number of occurances a month/year occur.
I have a column with dates mm/dd/yy. I have another column with mm/yy to
represent closings. Any help is appreciated!

A B C
Plan Elevation Projected Close - Year
2636 C Dec-05
3572 C Dec-05
3356 A Jan-06
3572 C Dec-06
2896 A Feb-06

Closings answer should be
Dec-05 2
Jan-06 1
Feb-06 1
Mar-06 0