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 and 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 the datum go over specific date, for example 1.2.2005, change color to red.
I don't know, how to add days to date, and I don't know, how exactly build up a condition.

Thanks in advance

Satucha

[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

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"satucha" <[email protected]> wrote in
message news:[email protected]...
>
> Hi Excel gurus,
> Does anybody know, how to add for example 70 days to date in cell and
> 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 the
> datum go over specific date, for example 1.2.2005, change color to
> red.
> I don't know, how to add days to date, and I don't know, how exactly
> build up a condition.
>
> Thanks in advance
>
> Satucha
>
>
> --
> satucha
> ------------------------------------------------------------------------
> satucha's Profile:
http://www.excelforum.com/member.php...o&userid=26621
> View this thread: http://www.excelforum.com/showthread...hreadid=488092
>