Date Warning
That worked!! Your are great!!!
Thank you again,
Sue
"JE McGimpsey" wrote:
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???
|