Setting up alert on a different page

[Steven Tavener]

Hello. Is there a way to select a whole row of dates, all will be different, and set an alert to go off in a different location ie - sheet 2 or Word? Thanks in advance.

[#2]

Sorry i meant to say set the alert to come up within a week of the due date

[#3 · Accepted solution]

Suppose the column A is the list of dates with A1 as the header.

Then, in column B, I would try the following formula (in cell B2):

               =IF(and(A2-today()<7, A2-today()>0), "ALERT", "")

Hope that this can help you.

[#4]

Thank you, with a few small tweaks i figured out what i needed. Your help is appreciated.

[#5]

Sorry one more question, is there a way to set the alert up for dates that are after todays date?

[#6]

The function today() will return the value of today, so the following formula will help

                                               IF(A2 > TODAY(),"ALERT","")

[#7]

Once again thamk you for your help.