Text in Date Column Messing Up Formula
I have 8 date columns where sometimes I enter text. Either the date of a document's expiration, or if the document was simply "received."
I have another helper column that I want to be checked off if any of the 8 dates are expired. BUT I'm finding if I have text in any one of them, the formula becomes "invalid operation."
I've already tried these conditions, but I still get "invalid" if a date column has text, even if one of the other columns is expired:
=IF(AND(ISDATE([date column]),[date column] < TODAY()),1
=IF(AND(NOT(ISTEXT([date column])),[date column] < TODAY()),1
=IF(AND(NOT([date column]="received"),[date column] < TODAY()),1
The truth is if I had only 1 date column, I would do something like:
=IF(ISTEXT([date column]),"", IF([date column] < TODAY(), 1
But I have 8 to contend with. And I'm doing a nested OR function within the IF because I only need the checkbox to check off if [date column1] is expired or [date column2] is expired or etc.....
Thanks for any and all help.
Help Article Resources
Check out the Formula Handbook template!