Feb 07 2022 08:00 AM
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!
Feb 07 2022 08:10 AM
SolutionIn D1 you have text which only looks like date. Dates in Excel are actually numbers and any text is always "more than" any number.
Feb 07 2022 08:16 AM
Feb 07 2022 09:57 AM
@keltzjd , you are welcome
Feb 07 2022 08:10 AM
SolutionIn D1 you have text which only looks like date. Dates in Excel are actually numbers and any text is always "more than" any number.