What formula do I use to add 12 months to a date?

Kim Mauger
edited 04/16/20 in Formulas and Functions

I have created a smartsheet form for contractor inductions. In one of the columns is the date at which the contractors completed induction was reviewed internally. I now need to create a formula that automatically populates the cell with a date that is 12 months from the review date as this will highlight when the contractor next has to be reviewed.

I'm having trouble making a formula work. Can you help me with this?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!