# \[DONE\] Add a number of months to a date

**URL:** <https://community.fibery.io/t/done-add-a-number-of-months-to-a-date/4695>\
**Category:** Misc\
**Created:** [June 30, 2023, 7:52am UTC](https://community.fibery.io/t/done-add-a-number-of-months-to-a-date/4695 "2023-06-30T07:52:43Z")\
**Posts on this page:** 1\
**Showing post:** 5

<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:** [June 30, 2023, 11:39am UTC](https://community.fibery.io/t/done-add-a-number-of-months-to-a-date/4695/5 "2023-06-30T11:39:33Z")

</div>

Something like this should work

```auto
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) + IntervalPeriod) / 12, 0),
        1
      ) - Days(1)
    ),
    Day(CurrentDate)
  )
)

```

You’d use Paid Terms instead of IntervalPeriod

---

_[View the full topic](https://community.fibery.io/t/done-add-a-number-of-months-to-a-date/4695)._