i have added the three rules
are you using excel 2003
and used today
so if in the cell D8
you put
=today()-xx
where xx is the number of days you want to go back
so =today()-90
=today()-60
see if that works OK
does not need to test A5 , unless you need that as part of the test
Bookmarks