Date formula to set cut off period

Adedeji Adebanjo

I am trying to set a date formula to for the following statement;

if the [Next Due Date] is <= 27/07/2023 return "Performed"

Example:

=IF(ISBLANK([Last inspection]@row), "", IF(DATE(2023,7,27)) < [Next Due Date]@row, "Overdue", "Performed"))

Paul Newcome

Try removing one of the closing parenthesis after the DATE function.

Adedeji Adebanjo

Thanks! That sorted it!😀

Paul Newcome

Try removing one of the closing parenthesis after the DATE function.

Adedeji Adebanjo

Thanks! That sorted it!😀

Paul Newcome

Happy to help. 👍️