I have a field in the products called RPG_LeadTime and this is the product lead time before we are expecting to dispatch the product.

So if the date is 23.12.2019 and the lead time it two days then it should show the 26.12.2016 (Just ignore its Christmas)

So i need help creating a formula to get today's date then add the variable number of working days to it to get the new updated dispatch date.

I am being a bit blond today so sorry.


I'm assuming you mean to use this in a formula field and RPG_LeadTime__c is a number field but the below formula should work for you.

TODAY() + RPG_LeadTime__c

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.