Formula to add days, adds years instead


Trying to add days to a date from another column on the same sheet, but it adds digits to the years format instead.

Date Source = 08/12/22.

Cell Formula =Date@row + 20

Expected Answer = 09/09/22.

Actual Answer = 08/22/2220.

Please assist and advise.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!