Skip to main content
Topics#Data ManagementPat O'Crosain의 질문
Pat O'Crosain (C-CRM) 님이 #Data Management에 질문했습니다
2018년 11월 14일 오후 2:17

Formula for date outside of weekend

I need to write a formula that calculates (specific_date__c + 7), but I need these 7 days to exclude the weekend when returning the result. We're based in the Middle East, and our weekend is Friday and Saturday, not Saturday and Sunday.

 

Could someone help with this please?
답변 7개
  1. Sunil Sarilla (M&G Investments)
    2018년 11월 14일 오후 2:30
    Hi Pat,

     

    Please give this a shot

    Date_Field__c +
    CASE(WEEKDAY(Date_Field__c),
    1,9,
    2,9,
    3,9,
    4,11,
    5,11,
    6,10,
    7,9,
    NULL)

    Please use the insert field button to select the field API Name of Date field

     

     
답변을 작성하세요...
0/9000