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