Try =SUMPRODUCT(--(D13:D19D7),--(D13:D19<F7))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"Frick" wrote in message
...

D7=Start Date F7=End Date

B13:B31 Data Dates
C13:C31 Data

I need a formula that will count the number of entries in range
C13:C31 that are between the dates in D7 and F7.

Thanks for your help.


--
Frick
------------------------------------------------------------------------
Frick's Profile:
http://www.excelforum.com/member.php...o&userid=29629
View this thread: http://www.excelforum.com/showthread...hreadid=493772