Forum Discussion
Solved
IF AND formula isnt working properly to find date between dates
Hello all! My IF AND formula isn't working properly when trying to find if a date is between my start and complete date and it's driving me crazy. Can anyone help please? I've attached the dataset. I'm trying to use it to make a Gantt chart but I can't even get it working X_X
My current formula is:
=IF(AND($D$1>=A3, $D$1<=B3), "Yes", "No")
It keeps returning No when the referenced date IS between the start and complete date 😞
Thank you all!
In D1 you have text which only looks like date. Dates in Excel are actually numbers and any text is always "more than" any number.
