Carol Frangipane
Registered User.
- Local time
- Today, 10:04
- Joined
- Jul 11, 2007
- Messages
- 19
Hi Guys: I have got myself in a formula nightmare...I've written it so many different ways, that I forgot what exactly I was trying to do!
Here is my scenario:
A contract's original expiration date is mm/dd/yyyy [EndTerm]
Once it passes that date, it automatically renews for nn years [Renew]
Basing everything on the current date, I am trying to calculate that it has autorenewed x times [AutoRNo] .... whole number...no decimal places
I then need to calculate a "Next Expiration Date" which adds the number of years that have renewed to the [EndTerm]. So if a contract renewed for 3 years, and it renewed twice, the next expiration date would be 6 years after the orig expiration date [EndTerm].
I am just making a complete mess out of it.
If you can guide me through this, I'd appreciate it. I'm taking an Excedrin now....Thanks for any assistance.
Carol
Here is my scenario:
A contract's original expiration date is mm/dd/yyyy [EndTerm]
Once it passes that date, it automatically renews for nn years [Renew]
Basing everything on the current date, I am trying to calculate that it has autorenewed x times [AutoRNo] .... whole number...no decimal places
I then need to calculate a "Next Expiration Date" which adds the number of years that have renewed to the [EndTerm]. So if a contract renewed for 3 years, and it renewed twice, the next expiration date would be 6 years after the orig expiration date [EndTerm].
I am just making a complete mess out of it.
If you can guide me through this, I'd appreciate it. I'm taking an Excedrin now....Thanks for any assistance.
Carol
