R
Richard
I am using Windows XP and Excel 2000.
I have 2 worksheets 1) Data 2) betwen_2_dates
In the sheet between_2_dates the cell D2 has this date input 01/01/2007
In the sheet between_2_dates the cell G2 has this date input 31/12/2007
In the sheet between_2_dates the cell B2 has this formula
=SUMPRODUCT(--(Data!$A$1:$A$10000>=D2),--(Data!$A$1:$A$10000<=G2))
In the sheet Data column A has the info. In column A cell A1 of sheet Data
there is the following text "MainDate". In sheet Data column A cells A2 to
A134 there are dates which all fall between 01/04/2007 and 30/06/2007.
However in sheet between_2_dates cell B2, the number that is displayed is
132. But the number should be 133.
Any idea what is causing the formula to display 1 less than it should do?
Many thanks for any help with this.
I have 2 worksheets 1) Data 2) betwen_2_dates
In the sheet between_2_dates the cell D2 has this date input 01/01/2007
In the sheet between_2_dates the cell G2 has this date input 31/12/2007
In the sheet between_2_dates the cell B2 has this formula
=SUMPRODUCT(--(Data!$A$1:$A$10000>=D2),--(Data!$A$1:$A$10000<=G2))
In the sheet Data column A has the info. In column A cell A1 of sheet Data
there is the following text "MainDate". In sheet Data column A cells A2 to
A134 there are dates which all fall between 01/04/2007 and 30/06/2007.
However in sheet between_2_dates cell B2, the number that is displayed is
132. But the number should be 133.
Any idea what is causing the formula to display 1 less than it should do?
Many thanks for any help with this.