Conditional Formatting with dates
If the training date is in cell A1 and the years it is valid is in cell A2
then apply this conditional formatting to cell A1:
Condition - Cell Value - is less than -
=DATE(YEAR(TODAY())-B1,MONTH(TODAY()),DAY(TODAY()))
This formula is based on the current date but could be modified to work with
any date you specify.
Tom
|