D
Danny Boy
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
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