How to auto calculate dates

WinaHath

This works if the contract term is 3 years then End Date but it won't work if the contract term is another number. How do I make it auto calculate if the contract term is 1, 2, 3 or 5 years?

Thanks!

Wina

Toufong Vang

Hi, @WinaHath .

Rename the column "Contract Term [Years]" to use parentheses, "Contract Term (Years)".

In your original formula, replace "3" with [Contract Term (Years)]@row .

Your updated formula will be =DATE(YEAR([Effective Date]@row) + [Contract Term (Years)]@row, MONTH([Effective Date]@row), DAY([Effective Date]@row)) .

Toufong Vang

Hi, @WinaHath .

Rename the column "Contract Term [Years]" to use parentheses, "Contract Term (Years)".

In your original formula, replace "3" with [Contract Term (Years)]@row .

Your updated formula will be =DATE(YEAR([Effective Date]@row) + [Contract Term (Years)]@row, MONTH([Effective Date]@row), DAY([Effective Date]@row)) .

WinaHath

THANK YOU SO MUCH!!