Calculate next renewal date

[Chr1sG]

Have you seen this?

Add a number of months to a date

Something like this should work Date( Year(CurrentDate) + RoundDown((Month(CurrentDate) + IntervalPeriod - 1) / 12, 0), Month(CurrentDate) + IntervalPeriod - 12 * RoundDown((Month(CurrentDate) + IntervalPeriod - 1) / 12, 0), Least( Day( Date( Year(CurrentDate) + RoundDown((Month(CurrentDate) + IntervalPeriod - 1) / 12, 0), Month(CurrentDate) + IntervalPeriod + 1 - 12 * RoundDown((Month(CurrentDate) + IntervalPer…

I think it could be adapted to achieve what you need