IF(ISDATE) not working?

arw88

I have "Column B" that pulls in a date from another sheet.

And I have "Column A" that changes to Complete when that date populates into Column B.

In addition, I have a criteria for which it should say "Eligible", "Not Yet Eligible", or "Missed".

This formula has been working just fine for a while. I have been updating a few things today and notice that it does not appear to be working now. I have went through the updates I made to see what could have made a difference but cannot come up with anything.

Also - the text criteria for "eligible", etc. is working okay - it is just the date criteria not working.

I simplified it down to just the isdate formula to double check, but still nothing.

The longer formula with text indicators is

=IF(ISDATE([Pre-Term C]@row), "Complete", IF(AND([Enroll GAW]@row >= 1, [Enroll GAW]@row <= 40, [Current GAW]@row >= 28), "Eligible", IF(AND([Enroll GAW]@row >= 1, [Enroll GAW]@row <= 40, [Current GAW]@row <= 28), "Not Yet Eligible", IF(AND([Enroll GAW]@row >= 1, [Enroll GAW]@row <= 40, ISDATE(DOB@row)), "Missed", IF([Enroll Years]@row > 0, "-", "")))))

Any thoughts on this appreciated, thank you!

Paul Newcome

Did you check that both the column in the sheet you have in your screenshot as well as the sheet for the source date are both date type columns? If so, exactly how are those being populated?

Paul Newcome

Did you check that both the column in the sheet you have in your screenshot as well as the sheet for the source date are both date type columns? If so, exactly how are those being populated?

arw88

Oh my - yes - the column in my main sheet was still a date which I had double checked, but when I updated my source sheet that column ended up being text instead of date. 🤦‍♀️ Appreciate your reminder to check on the basic things. Thank you!

Paul Newcome

Happy to help. 👍️