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...
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.
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.
- Siiiiiiiigh, so much headache for such a simple mistake. Thank you sir X_X
keltzjd , you are welcome
