Alerts
If you have a date in A1, the formula =DATE(YEAR(A1)+3,MONTH(A1),DAY(A1))
will give a date 3 years later.
Alternatively in conditional formatting if you use Formula Is:
=DATE(YEAR(A1)+3,MONTH(A1),DAY(A1))<=TODAY()
this will highlight any dates at least 3 years ago.
--
David Biddulph
"Mark" wrote in message
...
I have produced an excell programme for training. Is it possible to get a
reminder when mandatory training has expired ie first aid every 3 years ,
if
a staff member has recently completed the course is it possible that
excell
will remind me prior to the first aid expiring.
|