Formula Help

[TDawg1831]

This is a tricky one but hopefully someone will be able to help. I need to
create a formula that can will give me an updated date based on dates. I
have a effective date and term of contract. Now if the contract is renewable
I want the formula to be able to look at the effective date and extend it out
by the term, say 5 years, and give me the new date if that day hasn't passed
the current day. If it has then extend the contract by the term again.

My thought is that only a very intricate IF function will work. I think I
have it but am having trouble getting into formula terms.

Here's what I have

=IF(I3="Y",=IF(Time Between the current date and the effective date is =<
the term, then the effective date plus the term,effective date),=IF(Time
between the current date and the effective date is =< the term, then the
effective date plus the term, effective date))

[pinmaster]

Hi,
I'm not sure if this is what your looking for but try this:

=IF(A1="y",IF(DATEDIF(B1,TODAY(),"d")<=C1*365.24,B1+C1*365.24,B1+(2*(C1*365.24))),"")

B1 - effective date
C1 - term in years

Hope this helps
JG

[TDawg1831]

Thanks!!!!! That worked perfectly!!

TDawg1831

"pinmaster" wrote:

>
> Hi,
> I'm not sure if this is what your looking for but try this:
>
> =IF(A1="y",IF(DATEDIF(B1,TODAY(),"d")<=C1*365.24,B1+C1*365.24,B1+(2*(C1*365.24))),"")
>
> B1 - effective date
> C1 - term in years
>
> Hope this helps
> JG
>
>
> --
> pinmaster
> ------------------------------------------------------------------------
> pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
> View this thread: http://www.excelforum.com/showthread...hreadid=482987
>
>