Creating dates to increment by month, how do I move to a new year when month equals 12?

Here is the formula I used: =DATE(YEAR(Date3), MONTH(Date3) + 1). It works great for dates up to the 12th month (December). How

do I modify the formula to go to January of the next year, e.g. 12/01/20 to 01/01/21?

Thanks, Susan

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!