Date Warning

S

smack

My spreadsheet has dates that employees were certified on. In one cell I
have that such date. I would like to have the adjacent cell add 6 months and
turn red if it goes over. Any advise???
 
J

JE McGimpsey

Add 6 months:

A2: =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))

To turn red, use Format/Conditional Formatting...

CF1: Formula is =TODAY()>A2
Format1: <patterns>/<red>
 
Top