Adding XY days to date in cells

[satucha]

Hi Excel gurus,
Does anybody know, how to add for example 70 days to date in cell an
then use it in condition ?
I have column with date in every cell. I need the date go to red color
when I add to date 70 days and the date go over specific date.

Example - I have some date : 1.1.2005, now, if I add 70 days and th
datum go over specific date, for example 1.2.2005, change color t
red.
I don't know, how to add days to date, and I don't know, how exactl
build up a condition.

Thanks in advance

Satuch

 

[Max]

One way, via conditional formatting ..

Assuming real dates are in col A, in A1 down

Select col A (A1 active)
Click Format > Conditional Formatting
Under condition 1, put it as:
Formula is: =AND(TODAY()-A1>=70,A1<>"")
Format to taste, OK out