In C1:
=SUMPRODUCT((A1:A10<=--"10-Oct-2007")*(B1:B10=--"10-Oct-2007"))
where A1:A10 = start dates, B1:B10 = end dates
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Quovardis" <u38145@uwe wrote in message news:7981a2847c766@uwe...
Hi,

Ive been looking all over for a solution for this.

I basically want to count the amount of times a date falls between 2
dates.
The problem is that my start & end date are in different columns of a row
and
I have 100's of Rows that have the start and end date

Example of data:

Column 1 Column 2
Row1 10/8/2007 10/11/2007
Row2 10/9/2007 10/12/2007

So in this example I want to count how many times 10/10/2007 will fall on
or
between the dates in column1 & column2.

The correct answer would be 2 in this case.

Hope someone can help as im doing my head in with this one.

BR.....Q