Forum Discussion
Solved
Setting up alert on a different page
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.
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.
6 Replies
- Sorry i meant to say set the alert to come up within a week of the due date
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.
- Once again thamk you for your help.
