How can I add a number of days to a date column in the same sheet?

Carolina Rivera
edited 05/22/20 in Formulas and Functions


I currently have a column that is supposed to add 14 days to another date column in the same sheet. The formula I'm using is: =["Date Column"] + 14

However, what I keep getting is "Apr 21, 2020 3:10 PM14". Both columns are date columns.

Thanks so much in advance!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!