Formula to add days, adds years instead

Options

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.

Thanks.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!