Issue adding value to date field

Options

I'm trying to populate a field that adds a value to a date to calculate a new date. However, the date field I'm trying to add to is a vlookup from a different sheet.

My formula is this:

=[Current Ex-Factory Date]@row + 63

The value under [Current Ex-Factory Date] is 10/26/22 so I would expect the result to be 11/05/22, however 10/26/2263 is what shows up.

If I key the [Current Ex-Factory Date] instead of the vlookup, the formula works as expected. Is there a workaround where I can keep the vlookup and avoid having the +63 treated as concatenate?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!