I have the following formula which is working great (as far as it goes):
=IF(AF6>AA6,"Not due yet",IF(AF6>AA6+7,"~ 7 days late","+ 7 days late"))
AF6 is Last Review Date
AA6 is todays date.
So the formula is looking to show:
If the Last Review date is overdue return one of the messages...