# \[DONE\] Months() and Years() function in formula

**URL:** <https://community.fibery.io/t/done-months-and-years-function-in-formula/7620>\
**Category:** Ideas & Features\
**Tags:** formulas\
**Created:** [October 19, 2024, 9:28pm UTC](https://community.fibery.io/t/done-months-and-years-function-in-formula/7620 "2024-10-19T21:28:18Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [October 20, 2024, 7:24am UTC](https://community.fibery.io/t/done-months-and-years-function-in-formula/7620/2 "2024-10-20T07:24:07Z")

</div>

Related

> [@\[DONE\] Add a number of months to a date](https://community.fibery.io/t/add-a-number-of-months-to-a-date/4695):
>
> I need to add a number of months (in Paid Terms field) to a date (in License From field). This is what I was able to do figure out so far: Date(If(Month([License From]) + [Paid Terms] \> 12,Year([License From]) + 1,Year([License From])),If(Month([License From]) + [Paid Terms] \> 12,Month([License From]) + [Paid Terms] - 12,Month([License From])),Day([License From])) Sadly, it doesn’t work. The calculated field shows exactly the same date as in License From. Nothing is being added. :-/ I’ve alr…

---

_[View the full topic](https://community.fibery.io/t/done-months-and-years-function-in-formula/7620)._