More date/counting functions
 

I need G2 to start counting DOWN when F2 is 150 days out from TODAY's date
F G H
1 Exp. Date Req Due to Terminal Request Rec'd
2 10/31/08 -99 07/21/08

and then stop counting when H2 gets populated with a date (in theory, the
requests will come in way before F2's dates, such as in the above instance)

of course, with making sure G2 stays blank if:
1. F2 is blank AND
2. F2 is more than 150 days from TODAY

Is this even possible?!

More date/counting functions
 

Hi,

See if this works for you

=IF(OR(F2="",F2TODAY()+150),"",IF(H2<"",H2-F2,F2-TODAY()))

Also I don't understand you sample numbers, I would expect G2 to be -102?


If this post is helps please click Yes.
--
Thanks,
Shane Devenshire


"HeatherBelle" wrote:

I need G2 to start counting DOWN when F2 is 150 days out from TODAY's date
F G H
1 Exp. Date Req Due to Terminal Request Rec'd
2 10/31/08 -99 07/21/08

and then stop counting when H2 gets populated with a date (in theory, the
requests will come in way before F2's dates, such as in the above instance)

of course, with making sure G2 stays blank if:
1. F2 is blank AND
2. F2 is more than 150 days from TODAY

Is this even possible?!

More date/counting functions
 

Works perfectly!! You rock my world!!

I had something started that looks similar, but I'm not used to thinking
this way nor am I familiar with what all my options are in Excel (though I
LOVE learning new things like this)... I'm an English major! HAHA

"ShaneDevenshire" wrote:

Hi,

See if this works for you

=IF(OR(F2="",F2TODAY()+150),"",IF(H2<"",H2-F2,F2-TODAY()))

Also I don't understand you sample numbers, I would expect G2 to be -102?


If this post is helps please click Yes.
--
Thanks,
Shane Devenshire


"HeatherBelle" wrote:

I need G2 to start counting DOWN when F2 is 150 days out from TODAY's date
F G H
1 Exp. Date Req Due to Terminal Request Rec'd
2 10/31/08 -99 07/21/08

and then stop counting when H2 gets populated with a date (in theory, the
requests will come in way before F2's dates, such as in the above instance)

of course, with making sure G2 stays blank if:
1. F2 is blank AND
2. F2 is more than 150 days from TODAY

Is this even possible?!