Date Formulas

Stuiebluie · Sep 29th 2004

Hi,

If i have a list of Quotes each with an estimator attributed to them and a date of submission, what formaula can i use to calculate the amount of quotes an estimator has done in august 2004 for instance.

fifijazz · Sep 29th 2004

If your quotes are in col a estimator in b, and date in col c, then:
=SUMPRODUCT((MONTH(C5:C10)=8)*(B5:C10="Bill")) will count all of the estimates Bill did in August. If you want to total the estimates then:
=SUMPRODUCT((MONTH(D5:D10)=8)*(C5:C10="Bill")*(A5:A10))

Stuiebluie · Sep 29th 2004

great thanks,

is it possible to define the month and year as my list has aug-04 and aug-03 or will i have to split the columns?

fifijazz · Sep 29th 2004

Sure.
=SUMPRODUCT((MONTH(C5:C10)=8)*(YEAR(C5:C10)=2004)*(B5:C10="Bill"))

Date Formulas

Participate now!

Share