function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Cynthia Rodgers 12Cynthia Rodgers 12 

Hi there, I am trying to create a formula date field that calculates/takes the created date of the record + 20 days. I also need to exclude weekends and holidays. I have setup the holiday calendar in our org.

Cynthia Rodgers 12Cynthia Rodgers 12
So my post was cut short but i have created a custom due date field on the case object called Audit Due Date.  This field needs to calculate off the Date/Time Opened (CreatedDate) field and add 20 days to that.  So my starting point is (Created Date + 20),  however I am not sure where to go from there.  So within that 20 days, i need to exclude holidays and weekends.   Im not seeing any formula scenarios that are excluding holidays or weekends from their date calculation.    
Tarun J.Tarun J.
Hello Cynthia,

Currently won't support to exclude holidays in Formula field. You need to write apex code to manage it.

Below is the link to Idea:
https://success.salesforce.com/ideaView?id=08730000000I75dAAC

-Thanks,
TK
Cynthia Rodgers 12Cynthia Rodgers 12
Thanks TK!