Adding Months Would be nice to simply add mo...

Adding Months

Would be nice to simply add months like with the EDATE funktion in EXCEL, or like shown in this Video:

https://www.youtube.com/watch?v=86M3TCpxk2Q

You can do the same with the concatenate and then choose the Date as a field type.

It’s not as simple as with Excel or gSheet, but it’s doable.

@Aleksi_Alkio Thank you. But when I add 13 months, it will not increase the year.

When I have [DateTime] = 01/30/2000 and I do DATE((MONTH([DateTime]) +13) & “/” & (DAY([DateTime])) & “/” & (YEAR([DateTime]))) It should give me 02/30/2001. But the result is just nothing, because it calculates 14/30/2000 and that is not a date.

You need to check from the month column is it 12 or more and then add more years. You don’t need to do the same with the Days because when you have calculated the month and year, you can just add those days.