J
Jman
Sheet 1
A1 to A200 i have dates
4/1/08
4/4/08
4/12/08
4/15/08
4/31/08
Sheet 2
I have two single dates.
A1: 4/1/08
A2: 4/15/08
In D2 Sumif any date falls equal to or between
A1: 4/1/08 and
A2: 4/15/08
Count dates value of "1" only.
From above example the result should be "4"
excluding 4/31/08 because it does not fall on or between dates in A1 and A2
A1 to A200 i have dates
4/1/08
4/4/08
4/12/08
4/15/08
4/31/08
Sheet 2
I have two single dates.
A1: 4/1/08
A2: 4/15/08
In D2 Sumif any date falls equal to or between
A1: 4/1/08 and
A2: 4/15/08
Count dates value of "1" only.
From above example the result should be "4"
excluding 4/31/08 because it does not fall on or between dates in A1 and A2