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
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!