+ Start a Discussion
Stephen Glaros 7Stephen Glaros 7 

Formula for adding custom number field (as days) to date formula?

Hi Community,

I thought this would be an easy formula, but haven't found any solutions posted. 

I have a custom date field, "Deliverable Date" and a custom number field, "Acceptance Period (Days)". 

If the Deliverable Date is 5/12/19 and the Acceptance Period (Days)" is 7, I'd like a fomula to add the 7 days to a custom formula field "Acceptance Date" that results in 5/19/19. And if the days were 6, then the Acceptance Date would be 5/18/19, and so forth.

Would this need to be a workflow vs. formula? Any advice would be appreciated. Thank you!

Best Answer chosen by Stephen Glaros 7
Andrew GAndrew G
A simple formula field
Type date
formula
Deliverable Date + Acceptance Period

example: Date_1__c + Acceptance_Period_Days__c

regards
Andrew

All Answers

Andrew GAndrew G
A simple formula field
Type date
formula
Deliverable Date + Acceptance Period

example: Date_1__c + Acceptance_Period_Days__c

regards
Andrew
This was selected as the best answer
Raj VakatiRaj Vakati
Please refer this link ........

https://opfocus.com/sfdc-formula-field-todays-date-plus-one-year/
 
DATE(CloseDate) + 364

or 
 
Date__c + Acceptance_Period_Days__c

 
Raju yadavRaju yadav
Hi Stephen Glaros 7,
Please Use Deliverable Date + Acceptance Period (Days) 

Thanks
Stephen Glaros 7Stephen Glaros 7
Andrew, Raj and Raju - thank you all for the quick responses - formula works perfect!

Rgds,
Stephen