Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The formula below triggers the flag "Enrollment Packet not returned" if more
than 3 months has elapsed from the date identified in cell AA3. Thus, if I place November 1, 2008 in cell AA3, the flag would appear once February 1, 2009 passes. What I'd like to do, however, is to change the date which triggers the flag from "three months" out to "ten days" out. So, if the date November 1, 2008 is placed in cell AA 3, I'd like the flag "Enrollment Packet not returned" to trigger 10 days later (November 11, 2008) as opposed to three months later. Below is the formula as I currently have it..... =IF(Y3="","",IF(AA3="","",IF(TODAY()EDATE(AA3,3), "Enrollment Packet not returned",""))) Thanks for the help! Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Charts forget range or data; fixed by manual alteration then Undo | Charts and Charting in Excel | |||
Vlookup alteration | Excel Discussion (Misc queries) | |||
Macro Code minor alteration please. | New Users to Excel | |||
16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) |