LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Formula alteration help!

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charts forget range or data; fixed by manual alteration then Undo Garth T Kidd Charts and Charting in Excel 1 February 8th 07 03:23 PM
Vlookup alteration nir020 Excel Discussion (Misc queries) 3 October 13th 06 01:41 PM
Macro Code minor alteration please. RPTZ New Users to Excel 6 July 10th 05 05:47 AM
16 digit number wont keep alteration unless format cell to text Croc001 Excel Discussion (Misc queries) 3 March 30th 05 09:12 AM


All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"