Adding 1 day to date in an If formula

Options

Hello.

I am trying to add one day to a date if the row meets a certain condition.

Instead of adding the day, it is putting a "1" at the end of the date string. I have confirmed both the original date and the column with the formula are formatted for date.

What else am I missing?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!