Conditional Date Alert

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
 

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

Top