Alerts

  • Thread starter Thread starter Mark
  • Start date Start date
M

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.
 
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.
 
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
 
Back
Top