# Calculate next renewal date

**URL:** <https://community.fibery.io/t/calculate-next-renewal-date/4810>\
**Category:** Get Help\
**Created:** [July 19, 2023, 1:38pm UTC](https://community.fibery.io/t/calculate-next-renewal-date/4810 "2023-07-19T13:38:04Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [July 19, 2023, 8:05pm UTC](https://community.fibery.io/t/calculate-next-renewal-date/4810/3 "2023-07-19T20:05:11Z")

</div>

Have you seen this?

> [@Add a number of months to a date](https://community.fibery.io/t/add-a-number-of-months-to-a-date/4695/5):
>
> 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

---

_[View the full topic](https://community.fibery.io/t/calculate-next-renewal-date/4810)._