How do I add a # of months to a specific date?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

How can I add a # of months to a specific date?

Say I have a numeric field with 1, 2, 3, 4, etc... another field that contains a date.

How do I formulate so that Date, plus the numeric field, gives me a future date?

Example: Numeric Field: 15. Date field: 02-04-2015. The formula field would combine those and output: 05-04-2016.

Any idea is greatly appreciated.

Photo of Ricardo Tsai

Ricardo Tsai

  • 40 Points

Posted 4 years ago

  • 0
  • 1
Photo of dwhawe

dwhawe, Champion

  • 908 Points 500 badge 2x thumb
You can use the AdjustMonth function:

AdjustMonth(Date d, Number m)



Use a Formula - Date field:

AdjustMonth([DateField],[NumberField])
Photo of Ricardo Tsai

Ricardo Tsai

  • 40 Points
Thanks dwhawe!!!!!