Alerts

[Mark]

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.

 

[David Biddulph]

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.

 

[Mark]

Thanks David
I understand it will give me a date but can excell remind me in 3 years time
to book someone on a training course