Cannot calculate future date based on two source fields.


When adding a set of days to a historical date usually that will give you a future date example:

=[Sale date]@row + [Delivery days]@row will give me a future date

When using Data mesh or Vlookup to bring the two source fields to another reference smartsheet, the delivery days will add to the year instead of the days, thus only increasing the "years" and not months nor days.

I have tried

=Date(Year([Sale date]@row), Month([Sale date]@row), Day([Sale date]@row) + [Delivery days]

=Date(Year([Sale date]@row), Month([Sale date]@row), Day([Sale date]@row + [Delivery days]

Please help!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!