Formula alteration help!

  • Thread starter Thread starter Danny Boy
  • Start date Start date
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
 
Hi,

Here is a shorter approach:

=IF(Y3="","",IF(AA3="","",IF(TODAY()>(AA3+10),"Enrollment Packet not
returned","")))
 
.. 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
---
 
Back
Top