Skip to main content
Freya Feigenspan (Wise) ha fatto una domanda in #Formulas

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 risposte
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    25 mag 2023, 08:53

    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)