One cell has a due date, in another cell I want a message to show 90 days prior and up to the due date “Send Reminder”.
On the due date the message should be “Due Today”, after the due date the message should read, “Past Due”.
I tried this but the 90 day thing is puzzling.
=IF((E64=""),"",IF((E64=TODAY()),"DUE TODAY",IF((E64>TODAY()),"PAST DUE",IF(E64=TODAY()+90,"SEND REMINDER",""))))
On the due date the message should be “Due Today”, after the due date the message should read, “Past Due”.
I tried this but the 90 day thing is puzzling.
=IF((E64=""),"",IF((E64=TODAY()),"DUE TODAY",IF((E64>TODAY()),"PAST DUE",IF(E64=TODAY()+90,"SEND REMINDER",""))))