View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
TomPl TomPl is offline
external usenet poster
 
Posts: 342
Default 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