LinkBack URL
About LinkBacks
I have B11 set to April 14, 2005. Cell B12 is =IF(TODAY()-B12>190,"more than 190 days"). I get a return of FALSE. I am getting a NAME? when I use TODAY. How do I define TODAY as today's date?
I have B11 set to April 14, 2005. Cell B12 is =IF(TODAY()-B12>190,"more than 190 days"). I get a return of FALSE. I am getting a NAME? when I use TODAY. How do I define TODAY as today's date?
Last edited by wrinkle35; 09-19-2005 at 12:40 PM.
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
<[email protected]> wrote:
>
>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 of
>FALSE. What am I doing wrong?
Sorry for the late reply.
I get a FALSE no matter what the date is. >190 days or less < 190 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 makes any difference?
Last edited by wrinkle35; 09-22-2005 at 04:22 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks