Try something like this:
=IF(COUNT(P3,R3)<2,"",SUMPRODUCT((MAIN!$B$10:$B$49 99=P3)*(MAIN!$B$10:$B$4999<=R3)))
where P3, R3 houses the start and end dates
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"capt" wrote:
I have the following formula.

=IF($A6="","",COUNTIF(MAIN!$B$10:$B$4999,"" &$A6 & ""))

How do I count between two dates in cells: P3 and R3?
--
capt