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



In article ,
smack wrote:

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???