Date Formula

[wrinkle35]

I am just wondering how I can tackle a specific formula.
I have a company list that is sorted by date. Is there a way that i
that date has not been changed in 190 days that it will be 'flagged' i
some way?.
I think that conditional formatting will solve that problem, but
don't know how to write the formula. Can anyone show me how to tackl
this? :confused

 

[R.VENKATARAMAN]

if i understood correctly use this formula in the cell next to the relvant
cell
If D11 is relevant cell having a date entry, type this in E11
=IF(TODAY()-D11>190,"more than 190 days")

 

[wrinkle35]

I get 'FALSE' when I try that formula. I have B11 set to April 14, 2005
Cell B12 is =IF(TODAY()-B12>190,"more than 190 days"). I get a return o
FALSE. What am I doing wrong

 

[Myrna Larson]

I assume you have a typo in your formula and you really mean TODAY()-B11 (not
B12).

If today is 19 Sep 2005, the result of the subtraction is 158 days.

Your formula specifies what the cell should display when the time span is
greater than 190 days. But you haven't said what the cell should display when
the result is <=190, and in that case Excel returns FALSE.

 

[wrinkle35]

Sorry for the late reply.
I get a FALSE no matter what the date is. >190 days or less < 19
days.
So what I have done is put the TODAY in A2 and referred back to it.
=IF(A2-C4>190,"more than 190 days").
That seems to work. I am using MS Excel 2003, I wonder if that make
any difference