Skip to main content
Freya Feigenspan (Wise) 님이 #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개
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    2023년 5월 25일 오전 8: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)