Skip to main content
Topics#Data ManagementPat O'Crosain's Question
Pat O'Crosain (C-CRM) asked in #Data Management
Nov 14, 2018, 2:17 PM

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 answers
  1. Sunil Sarilla (M&G Investments)
    Nov 14, 2018, 2:30 PM
    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

     

     
Write an answer...
0/9000