Need to return "days overdue" if "Completion date" is blank
I'm trying to show the number of days a project is overdue based on the Expected Date of Completion versus today's date, if the Date Repair Completed is blank or has text instead of a date in it (i.e. Cancelled).
I didn't know after searching if I could list if a "NOT date" so here is the best I could come up with and couldn't find a solution after about a half an hour of searching. I'd appreciate any help! I would be willing to use ISBLANK if needed and I can maybe filter out date cells that contain text.
I tried =IF(NOT(ISDATE([Date Repair Completed]@row, [Expected Date of Completion]@row - TODAY())), ""))
Help Article Resources
Check out the Formula Handbook template!