Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alerts | Excel Discussion (Misc queries) | |||
alerts for changes in workbook | Excel Discussion (Misc queries) | |||
alerts | Excel Worksheet Functions | |||
SLA violation alerts | Excel Discussion (Misc queries) | |||
Alerts? | New Users to Excel |