Count According to Date

G

Guest

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
 
B

Bob Phillips

=SUMPRODUCT(--(TEXT($A$2:$A$20,"yymm")=TEXT(M1,"yymm"))

where M1 holds the test date

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 dimensional date sort 1
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
When building a chart Dates are been included that are not in thedate range 1
countif date 2
date and time difference 19
IF statement using multiple criteria 1
Need to transform the dates to months 4
Pick value at intersection of location & date (MMM-YY) 2

Top