IF AND formula isnt working properly to find date between dates

[keltzjd]

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!

[#2 · Accepted solution]

@keltzjd 

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.

[#3]

Siiiiiiiigh, so much headache for such a simple mistake. Thank you sir X_X

[#4]

@keltzjd , you are welcome