Add 1 Month to Date for Multiple Years

PhilBakerOAC ✭✭
edited 11/19/22 in Formulas and Functions


I am trying to build a formula that will add one month to each cell as shown in the sheet below. When a new year starts however I get the error indicated below. Any thoughts on how to fix this are appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!