How to create a future date based on a date in another column?

springwud
springwud
edited 12/09/19 in Formulas and Functions

Hi,

I am looking to create a formula in a column that automatically calculates the date of 12 weeks from the date of deposit column. Can someone please help with the formula? I keep getting errors. Specifically I would like the "estimated completion date" column to be the "date of deposit" column plus 84 days.

Thanks!

Keren

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!