Date Formula Help!

KatieB

Hi All,

I am trying to find a simple formula that allows me to add months onto a date to get an automated due date.

So date completed column plus whatever figure i put in months column ( up to 12 months) and then this to populate in the Due date column.

James Keuning

=IFERROR(DATE(YEAR([Date Completed]@row), MONTH([Date Completed]@row) + Months@row, DAY([Date Completed]@row)), DATE(YEAR([Date Completed]@row) + 1, MONTH([Date Completed]@row) - Months@row, DAY([Date Completed]@row)))

KatieB

Hi James, this only works up to four months and everything else including 12 months is not correct

lilywramirez

Hi @KatieB - Have you tried converting it to days?

[Date Completed]@row + 90