It should work fine. Just re-tested it here.

Did you **adjust** the date to be compared in the suggested formula from:
10th Oct 2007 (as per your original post) to 1st Oct 2007 (in your latest
response below), ie did you use:

=SUMPRODUCT((A1:A10<=--"1-Oct-2007")*(B1:B10=--"1-Oct-2007"))

If the above still doesn't work, that means your source dates data in cols A
and B are not real dates. You can use Data Text to Columns to convert each
col in turn to real dates. Just select say, col A, click Data Text to
Columns. Click Next Next. In step 3, select Date, then choose from the
droplist: MDY, click Finish. Repeat for col B.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Quovardis" <u38145@uwe wrote in message news:7981e346487a7@uwe...
Hi Max,

Thanks for the swift reply but unfortunately it doesnt work

9/27/2007 10/5/2007
9/28/2007 10/5/2007
9/26/2007 10/5/2007
9/29/2007 10/5/2007
9/28/2007 10/5/2007
10/3/2007 10/5/2007
10/3/2007 10/5/2007

Basically in my sheet I have here,if im looking for how many times
10/1/2007
will be in the range then it would return 5 as correct answer.

Your formulae for some reason doesnt return this