Issue adding value to date field

BethC

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?

SmartLew

Hmm. This doesn't seem right and works fine when I test it.

So you have a vlookup that is bringing in a date to column "Current ex-factory date" and then a seperate column which adds 63 to this date?

Are all of your columns date columns?