# How to auto calculate dates

Options
✭✭✭✭

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

• ✭✭✭✭✭
Options

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))` .

• ✭✭✭✭✭
Options

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))` .

• ✭✭✭✭
Options

THANK YOU SO MUCH!!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!