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))

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,B 1+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

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,B 1+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