how to add months to a date?

DG 13

Hi team,

I'm trying to add X months from the yellow column to a date and get the result.

for ex: 01/01/2025 + 12 Months = 01/01/2026.

Is there any way to do so? Thanks in advance!

Adam Murphy

Try this: =IF(AND(ISDATE([Date]@row), ISNUMBER([Yellow Column]@row)), DATE(YEAR([Date]@row) + (FLOOR((MONTH([Date]@row) + [Yellow Column]@row - 1) / 12, 1)), IF(MOD(MONTH([Start Date]@row) + [Yellow Column]@row, 12) = 0, 12, MOD(MONTH([Date]@row) + [Yellow Column]@row, 12)), DAY([Date]@row)), "")