IF formula for date and text in the same cell.
I currently have this formula for a cell:
=IF(AND([Quote Validity]62 < TODAY(), ISDATE([Quote Validity]62)), "EXPIRED")
However, if I need to put anything other than a date for Quote Validity cell. It returns an "#INVALID OPERATION"
What needs to be added to that formula so when a text, besides a date is inputted, it doesn't input anything (cell is just blank).