I have 2 worksheets called 1) Data 2) between_2_dates.

The sheet called Data holds all the information.

I have the following formula in cell B2 of sheet between_2_dates:

=SUMPRODUCT(--(Data!$A$1:$A$10000=DATE(2003,01,01)),--(Data!$A$1:$A$10000<=DATE(2008,01,01)))

I am using this calendar control to enter a date in cell D2 and I2 of sheet
between_2_dates:

http://www.rondebruin.nl/calendar.htm

This works fine, but I need to include these 2 dates in the formula above,
so DATE(2003,01,01) will be replaced and use the date in cell D2 and
DATE(2008,01,01) will be replaced and use the date in cell I2.

What would be the complete formula to do this?

Many thanks for any help with this.

--
Richard