# Calculate Future Date

**URL:** <https://forums.knack.com/t/calculate-future-date/6349>\
**Category:** Feature Requests\
**Created:** [April 3, 2018, 8:16pm UTC](https://forums.knack.com/t/calculate-future-date/6349 "2018-04-03T20:16:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![TaraMele35074](https://avatars.discourse-cdn.com/v4/letter/t/df705f/32.png) [@TaraMele35074](https://forums.knack.com/u/TaraMele35074)\
**Post date:** [April 3, 2018, 8:16pm UTC](https://forums.knack.com/t/calculate-future-date/6349/1 "2018-04-03T20:16:00Z")

</div>

I would like to be able to add a number of months to an equation field.

For example, I am creating an HR database and one function will be to keep track of employee reviews. There will be a review in the Hire month (date of hire is a field and I extracted the month from the hire date) but there is a 1/2 year review.

Hire Date - 9/17/2011  
Review Month = September (used formula field)  
1/2 Year Review = Review Month + 6 months

---

<div class="post-metadata">

**Author:** ![JulianKirkness](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/juliankirkness/32/770_2.png) [@JulianKirkness](https://forums.knack.com/u/JulianKirkness)\
**Post date:** [June 28, 2018, 8:43am UTC](https://forums.knack.com/t/calculate-future-date/6349/2 "2018-06-28T08:43:24Z")

</div>

Indeed!

I read elsewhere that it's because it's too difficult which seems ridiculous. It is harder than days weeks or years though...

Months _should be there_ - it's probably the most often needed option!!

---

<div class="post-metadata">

**Author:** ![JacobHill21191](https://avatars.discourse-cdn.com/v4/letter/j/a587f6/32.png) [@JacobHill21191](https://forums.knack.com/u/JacobHill21191)\
**Post date:** [June 27, 2018, 10:59pm UTC](https://forums.knack.com/t/calculate-future-date/6349/3 "2018-06-27T22:59:11Z")

</div>

I'm with you Julian... scratching my head trying to understand why there isn't a month option.

---

<div class="post-metadata">

**Author:** ![JulianKirkness](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/juliankirkness/32/770_2.png) [@JulianKirkness](https://forums.knack.com/u/JulianKirkness)\
**Post date:** [April 5, 2018, 11:10am UTC](https://forums.knack.com/t/calculate-future-date/6349/4 "2018-04-05T11:10:30Z")

</div>

You can get pretty close to this in a calculated (Equation) field - but for some reason, Knack allow you to add Hours, Days, Week or Years only - not months!!

The following screenshot shows a calculation to add 26 weeks to a date:

 ![](https://support.knack.com/hc/user_images/klBGa-2s0pDWfaEgdbjFXA.png)I'm not sure why Months isn't an option as I would think it would be the most used! (Knack??)
