JediMasterAmanda
New Member
- Joined
- Jan 31, 2018
- Messages
- 2
Hello all! I am trying to set up a formula for the purpose of alerting me when a client's reminder email should be sent (14 days after acceptance), and when they are past their payment deadline (21 days after acceptance). To do this, I was trying to reference their acceptance email sent date (cell I3). The formula I made worked, just not the way I was hoping. How can I alter my formula so that the cell reads "Reminder" 14 days after the acceptance email date (cell I3), and "Remove" 21 days after the acceptance email date?
The formula I currently have is
=IF((OR(AND(TODAY() <I3+21, TODAY()<I3+14), TODAY() >=I3+21)), "REMINDER", "REMOVE")
The formula I currently have is
=IF((OR(AND(TODAY() <I3+21, TODAY()<I3+14), TODAY() >=I3+21)), "REMINDER", "REMOVE")