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
-
Hi Paul,
Yes they are date fields, I've also noticed an ' in the MLA Calc field where days to be added
So I would like to return a date based on RTB expiration + MLA Calculation in a date field, all I get is unparsable.
-
There's the issue. The apostrophe is converting the numbers to text values. See if this works...
=[RTB Exp Date]@row + VALUE([MLA Calc]@row)
Answers
-
What is the VLOOKUP formula?
It sounds like your dates are actually being stored as text strings that only look like date values. Have you double checked to ensure that the column is a date type column?
-
Hi Paul,
Yes they are date fields, I've also noticed an ' in the MLA Calc field where days to be added
So I would like to return a date based on RTB expiration + MLA Calculation in a date field, all I get is unparsable.
-
There's the issue. The apostrophe is converting the numbers to text values. See if this works...
=[RTB Exp Date]@row + VALUE([MLA Calc]@row)
-
Thanks, it worked.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 494 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!