We're looking to implement a custom formula field, which takes the CreatedDate (Date/Time opened) and adds on 20 business days (not including weekends). How could I achieve this with a formula?
For context, if the Case is not responded to by this date, we will then increase the priority/escalate to another user/queue.
Thank you in advance!
13 Antworten
Eric Praud (Activ8 Solar Energies) Forum Ambassador
Hi,
You could go with this if your formula returns a date/time:
CreatedDate+
CASE(WEEKDAY(DATEVALUE(CreatedDate)),
1,29,
7,30,
28)
If it returns a date:
DATEVALUE(CreatedDate)+
CASE(WEEKDAY(DATEVALUE(CreatedDate)),
1,29,
7,30,
28)