All:
Trying to get this formula to do what it needs to do.
=IF(AND(TODAY()-J1>=6=TRUE,TODAY()-J1>=15=TRUE),1,0)
J1 is a date for this example it would be April 16 2010
What I am trying to do is to get a cell to turn 1 notifying me that this date is now within the 15 day range.
Thanks again for your help
Bookmarks