Hi Guys,

Basically what I am after is a basic table with name/company/Serial/Date.

What I need is a format by where every date I enter on that particular day is to expire and be highlighted after 1 year.

So if I put today's date that the contractor had completed a site induction, which is valid for a year, he then came back for example just over a years time he would then be highlighted and need to re-do the induction.

Also, how would I color code dates that are valid (within a year)?

Thanks for your time guys.

Sal