I am trying to subtract one date from another using the Today() formula, but
if the value is greater than 250 I want to return the value of 0.

Can someone help?

=IF(A1-Today()250,A1-Today(),0)

with date in A1...

You can change the comparison according to your logic.

"JimG" wrote:

I am trying to subtract one date from another using the Today() formula, but
if the value is greater than 250 I want to return the value of 0.

Can someone help?

Perhaps I am being dense but it isn't working. Here is a sample of what I
have
A1 B1 C1
3/21/2009 Request Date Days in Processing
1/1/2008 445
3/21/09 is Today() and the result is 445. If it is under 200 I want it to
display the value, but if over 200 I need it to show zero.

I appreciate the help

"Sheeloo" wrote:

=IF(A1-Today()250,A1-Today(),0)

with date in A1...

You can change the comparison according to your logic.

"JimG" wrote:

I am trying to subtract one date from another using the Today() formula, but
if the value is greater than 250 I want to return the value of 0.

Can someone help?

If 1/1/2008 is in A1 and you want the result in B1 then enter this in B1
=IF((Today()-A1)<200,Today()-A1,0)

I had left out the () around the condition..

"JimG" wrote:

Perhaps I am being dense but it isn't working. Here is a sample of what I
have
A1 B1 C1
3/21/2009 Request Date Days in Processing
1/1/2008 445
3/21/09 is Today() and the result is 445. If it is under 200 I want it to
display the value, but if over 200 I need it to show zero.

I appreciate the help

"Sheeloo" wrote:

=IF(A1-Today()250,A1-Today(),0)

with date in A1...

You can change the comparison according to your logic.

"JimG" wrote:

I am trying to subtract one date from another using the Today() formula, but
if the value is greater than 250 I want to return the value of 0.

Can someone help?

Does this work?

=IF(A1-B2250,A1-B2,0)

Make sure the cell address are right. Sheelo used Today. I simply replaced
Today with the cell B2.

"JimG" wrote:

Perhaps I am being dense but it isn't working. Here is a sample of what I
have
A1 B1 C1
3/21/2009 Request Date Days in Processing
1/1/2008 445
3/21/09 is Today() and the result is 445. If it is under 200 I want it to
display the value, but if over 200 I need it to show zero.

I appreciate the help

"Sheeloo" wrote:

=IF(A1-Today()250,A1-Today(),0)

with date in A1...

You can change the comparison according to your logic.

"JimG" wrote:

I am trying to subtract one date from another using the Today() formula, but
if the value is greater than 250 I want to return the value of 0.

Can someone help?

If it is under 200 I want it to display the value,
but if over 200 I need it to show zero.

What if the difference *is* 200?

Try this:

A1 = today

=(B1-A1)*(B1-A1<200)

--
Biff
Microsoft Excel MVP


"JimG" wrote in message
...
Perhaps I am being dense but it isn't working. Here is a sample of what I
have
A1 B1 C1
3/21/2009 Request Date Days in Processing
1/1/2008 445
3/21/09 is Today() and the result is 445. If it is under 200 I want it to
display the value, but if over 200 I need it to show zero.

I appreciate the help

"Sheeloo" wrote:

=IF(A1-Today()250,A1-Today(),0)

with date in A1...

You can change the comparison according to your logic.

"JimG" wrote:

I am trying to subtract one date from another using the Today()
formula, but
if the value is greater than 250 I want to return the value of 0.

Can someone help?

Based on the OP's data layout, they can use either

=(A1-B1<200)*(A1-B1)
or
=IF(A1-B1200,0,A1-B1)

but if you really want to be cute then in C1 enter
=A1-B1
and then apply the following custom format to C1
[200]"0"

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"T. Valko" wrote:

If it is under 200 I want it to display the value,
but if over 200 I need it to show zero.

What if the difference *is* 200?

Try this:

A1 = today

=(B1-A1)*(B1-A1<200)

--
Biff
Microsoft Excel MVP


"JimG" wrote in message
...
Perhaps I am being dense but it isn't working. Here is a sample of what I
have
A1 B1 C1
3/21/2009 Request Date Days in Processing
1/1/2008 445
3/21/09 is Today() and the result is 445. If it is under 200 I want it to
display the value, but if over 200 I need it to show zero.

I appreciate the help

"Sheeloo" wrote:

=IF(A1-Today()250,A1-Today(),0)

with date in A1...

You can change the comparison according to your logic.

"JimG" wrote:

I am trying to subtract one date from another using the Today()
formula, but
if the value is greater than 250 I want to return the value of 0.

Can someone help?

PERFECT!!! Thanks to everyone for the help!

"T. Valko" wrote:

If it is under 200 I want it to display the value,
but if over 200 I need it to show zero.

What if the difference *is* 200?

Try this:

A1 = today

=(B1-A1)*(B1-A1<200)

--
Biff
Microsoft Excel MVP


"JimG" wrote in message
...
Perhaps I am being dense but it isn't working. Here is a sample of what I
have
A1 B1 C1
3/21/2009 Request Date Days in Processing
1/1/2008 445
3/21/09 is Today() and the result is 445. If it is under 200 I want it to
display the value, but if over 200 I need it to show zero.

I appreciate the help

"Sheeloo" wrote:

=IF(A1-Today()250,A1-Today(),0)

with date in A1...

You can change the comparison according to your logic.

"JimG" wrote:

I am trying to subtract one date from another using the Today()
formula, but
if the value is greater than 250 I want to return the value of 0.

Can someone help?