Months() and Years() function in formula

[Chr1sG]

Related

Add a number of months to a date

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…