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.


On Mon, 19 Sep 2005 10:41:38 -0500, wrinkle35
wrote:


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