# \[DONE\] Months() and Years() function in formula **URL:** \ **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:** 7\ **Page:** 1
**Author:** ![Jonathan1](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/jonathan1/32/10038_2.png) [@Jonathan1](https://community.fibery.io/u/Jonathan1)\ **Post date:** [October 19, 2024, 9:28pm UTC](https://community.fibery.io/t/done-months-and-years-function-in-formula/7620/1 "2024-10-19T21:28:18Z")
Will it be possible to add Months() and Years() function in formulas ? The idea is to be able to add or remove X months or X years from a date _(as we currently can do with Days() function)_. ---
**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")
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… ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [October 21, 2024, 6:49am UTC](https://community.fibery.io/t/done-months-and-years-function-in-formula/7620/3 "2024-10-21T06:49:11Z")
We are going to improve formulas next year only, no plans to do it this year so far ---
**Author:** ![Jonathan1](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/jonathan1/32/10038_2.png) [@Jonathan1](https://community.fibery.io/u/Jonathan1)\ **Post date:** [October 21, 2024, 8:59am UTC](https://community.fibery.io/t/done-months-and-years-function-in-formula/7620/4 "2024-10-21T08:59:17Z")
Thanks for the feedback. ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [January 9, 2025, 3:30pm UTC](https://community.fibery.io/t/done-months-and-years-function-in-formula/7620/5 "2025-01-09T15:30:29Z")
`Months(x)` formula released today > [@January 9, 2025 / partying\_face Set any relative value in Date Filter, Batch change fields for selected entities, Improved readability in rich text fields, some new formulas](https://community.fibery.io/t/january-9-2025-set-any-relative-value-in-date-filter-batch-change-fields-for-selected-entities-improved-readability-in-rich-text-fields-some-new-formulas/8082#p-30013-monthsnumber-add-month-to-a-date-5): > > First release in 2025 brings you some good stuff! partying_face Set any relative value in Date Filter We’ve significantly expanded our Date Filter capabilities to support more flexible time-based filtering. When filtering by Date Field, you can now choose from convenient preset options like “today,” “yesterday,” and “one week from now,” or use the “custom date” option to select either specific dates or relative timeframes. The “is within” operator has also received a major upgrade. You now h… ---
**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:** [January 9, 2025, 3:53pm UTC](https://community.fibery.io/t/done-months-and-years-function-in-formula/7620/6 "2025-01-09T15:53:37Z")
Marked as solved, since adding n years is the same as adding 12 x n months ---
**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:** [January 9, 2025, 3:53pm UTC](https://community.fibery.io/t/done-months-and-years-function-in-formula/7620/7 "2025-01-09T15:53:40Z")