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

=IF(Y3="","",IF(AA3="","",IF(TODAY()DATE(YEAR(AA3 ),MONTH(AA3),DAY(AA3)+10),"Enrollment Packet not returned","")))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---
"Danny Boy" wrote:
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

As always, thank you Max...............Dan

"Max" wrote:

=IF(Y3="","",IF(AA3="","",IF(TODAY()DATE(YEAR(AA3 ),MONTH(AA3),DAY(AA3)+10),"Enrollment Packet not returned","")))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---
"Danny Boy" wrote:
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

Welcome, Dan. Pl take a moment to press the "Yes" buttons below from where
you're posting/reading this.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---
"Danny Boy" wrote:
As always, thank you Max...............Dan

Hi,

Here is a shorter approach:

=IF(Y3="","",IF(AA3="","",IF(TODAY()(AA3+10),"Enr ollment Packet not
returned","")))


--
Thanks,
Shane Devenshire


"Danny Boy" wrote:

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

.. shorter approach
True. But sometimes think it is also good to give an "intuitively" generic
version (albeit longer) which can easily be applied to other aging check
scenarios, eg if the trigger condition was instead: 2 months and 15 days,
etc
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000, Files:362, Subscribers:61
xdemechanik
---