 ShowAll Questionssorted byDate Posted Shannon Andreas 1

# Need a future date formula

Hello!

I was wondering if someone could help me out with a formula.

I need a formula that calculates the future date of a contract expiration.So the case goes like this:

Effective Date of contract year 1 = Service_Effective_Date__c
End date of contract year 1 = 12 months from Service_Effective_Date__c
Effective Date of contract year 2 = End date of Contract year 1 + 1 day
End Date of contract year 2 = 12 months from Effective Date of contract year 2
Effective Date of contract year 3 = End date of Contract year 2 + 1 day
End Date of contract year 3 = 12 months from Effective Date of contract year 3

Of course, I tried adding 365 days, but as you all know, that won't account for leap years and varying numbers of days in a month.

There is a contract term field which indicates the term in months of a contract if that would be easier to use.

Any help is appreciated.

Shannon pcon
Take a look over this documentation .  This will show you how to add years and days in your formula. Adam Coppin