Alerts
 

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.

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.

Alerts
 

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

"David Biddulph" wrote:

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.