Conditional Date Alert

  • Thread starter Thread starter Trainer742
  • Start date Start date
T

Trainer742

I need to create a two stage date dependent alert. The first stage alert
would tell me that a due date was occuring in 5 days. The second stage alert
would tell me that the due date is the current date.

I currently have the sccond alert functioning as follows:
1. one cell displays the current date
2. a colum dispalys the due date
3. a column adjacent to the due date displays ALERT using the formula
=IF(B2=$A$2,"DUE","")

I ned to display an alert if =or < five days prior to the due date.

Thanks
Trainer742
 
Note that you don't need to reference an outside cell to get current date.
Following formula diplays "DUE" if due date is today, or past, and alert if
within 5 days

=IF(TODAY()>=B2,"DUE",IF(TODAY()+5>=B2,"ALERT",""))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there any way to alert you when you are approaching a date? 2
tag / link a cell comment (date) to alert when due 3
conditional formatting on date where today is > or = datevalue 3
Email alerts 4
Can dates entered Excel be flagged up in Outlook? 7
Excel Excel due and overdue date colours 2
CELL FORMULAS 3
[Flashing] RED before renewal date 1

Back
Top