+ Start a Discussion
Hughbert StrongHughbert Strong 

Date Field Formula based on Additional Months

Hello All,

I have 2 date fields and a number field.

Date Fields: Start Date, End Date
Number Field: Subscription Term

I would like to populate the End date based on the Subscription Term. Example: Start Date = 2/13/2017, Subscription Term 13 months, End Date = 3/13/2018.

Not sure how to start writting a formula for this. 

Thanks,
Hieu
Best Answer chosen by Hughbert Strong
Roshni RahulRoshni Rahul
Hi Hughbert,

 Texted base formula:

DATE( Year([start date])+floor((MONTH([start date]) + [# of months] - 1) / 12) , 
    mod(MONTH([start date]) + [# of months] -1, 12) + 1 , 
     day([start date])
) - 1

Check out the link below which I got from success community.
https://success.salesforce.com/answers?id=90630000000gymAAAQ

Hope it helps you. If it helps, mark this answer as solved.

Regards,
Roshni