Hello everyone,
I am trying to write a function that gives below output:
If date reviewed on or before the due date or within one week after the due date, the outcome should be "On-time" else "Not On-time"
If date reviewed is blank and the due date has already passed the output should be No. of Days Overdue
If date reviewed is blank and the due date is in future the output should be No. of Days to deadline
I am using below function, but it says #UNPARSEABLE. Can someone help me resolve the issue.
=IF(AND(ISDATE([Date reviewed]@row), OR([Date reviewed]@row <= [Due date]@row, [Date reviewed]@row <= [Due date]@row+7)), "", IF(ISBLANK([Date reviewed]@row), IF([Due date]@row<TODAY(), DATEDIF([Due date]@row, TODAY(), "D"), DATEDIF(TODAY(), [Due date]@row, "D")), ""))
Thank you.
