Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Date Alert
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tag / link a cell comment (date) to alert when due | Excel Discussion (Misc queries) | |||
Alert date | Excel Worksheet Functions | |||
Cond Format: Expiry Date Alert | Excel Discussion (Misc queries) | |||
How do I create an alert of expiration date in Excel? | Excel Discussion (Misc queries) | |||
Date Alert | Excel Worksheet Functions |