Forum Discussion
Date interval check between columns
So i have dates in a column, B and say there are start and end dates in column D and E, I have to check if date in B1 matches in the interval of D and E, if any date falls in the interval of D and E,...
Mahdia_Akter Not sure what the > and < are supposed to do. Especially the semi-colon seems out of place. Perhaps this will work for you
=($B1>=$D$1:$D$200)*($B1<=$E$1:$E$200)
This should spill and array of ones and zeros. 1 indicating that the Date falls between the Start- and End Date, 0 that is does not.
- Thanks, trying with it too.
Mahdia_Akter If it's conditional formatting you need, perhaps the picture below helps.
Green falls within the period. Red does not.
