I'm simply trying to add 2 days to a date (ex: 1/1/22) to get a date 2 days from now (ex: 1/3/22).

When I use the simple formula =Start6 + 2 it's concatenating and I'm getting 1/1/222 instead of the expected 1/3/22. All dates are in a date column (Start) and there are no dependencies in the sheet.

What's going on here? I've used this function many times before and this has never happened!?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!