how to pull Date from the required Date

Hello team.

It is very difficult to explain in words what I want to do, but I will try.
everything should be clear in the screenshot.

I have a LI: days shift - the number of days for which the data will be shifted.
I have a date - just START()
and
date days shift after - the date on which the data will be shifted.

In the date value from I should get the date from which the data shifted.
That is, conditionally for 27 Jul 24 it should be 03.07.2024 (D/M/Y) because the data on 3 Jul 24 is shifted 24 days ahead

Which formula should I use, I will be glad of your help.

Accepted answers

All comments

alexpavel

@isakovbekzod you could use the POST ..but you need to transform the days in NUMBER… see below not a polished solution:

hope it helps,

Alex

isakovbekzod

@alexpavel

Hello! Thank you so much for your reply.
There is one thing. I forgot to add that - unfortunately I can't use POST, as I need to calculate the line item date value from precisely in order to optimize POST functions in a heavy module.

It is conditional that

IF Value[Lookup: Date value from] <> 0
then post(value, days shift)
else 0

and it does not take a lot of zeros and does not load the model.
That's why I have to calculate line item date value from another way (not POST). Sorry that I didn't specify the final goal in advance.

Quick Links

Can you help?

Unanswered questions

Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
PlanIQ Error Messages and Warnings
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…