Hi,

I am trying to create a formula fied which return number of days between two dates while excluding ONLY sundays.

I am trying with the formula below as base :
CASE(MOD( Date_de_reception__c - DATE(1985,6,24),7),
 
  0 , CASE( MOD( Date_de_prise_en_charge__c - Date_de_reception__c ,7),1,2,2,3,3,4,4,5,5,5,6,5,1),
  1 , CASE( MOD( Date_de_prise_en_charge__c - Date_de_reception__c ,7),1,2,2,3,3,4,4,4,5,4,6,5,1),
  2 , CASE( MOD( Date_de_prise_en_charge__c - Date_de_reception__c ,7),1,2,2,3,3,3,4,3,5,4,6,5,1),
  3 , CASE( MOD( Date_de_prise_en_charge__c - Date_de_reception__c ,7),1,2,2,2,3,2,4,3,5,4,6,5,1),
  4 , CASE( MOD( Date_de_prise_en_charge__c - Date_de_reception__c ,7),1,1,2,1,3,2,4,3,5,4,6,5,1),
  5 , CASE( MOD( Date_de_prise_en_charge__c - Date_de_reception__c ,7),1,0,2,1,3,2,4,3,5,4,6,5,0),
  6 , CASE( MOD( Date_de_prise_en_charge__c - Date_de_reception__c ,7),1,1,2,2,3,3,4,4,5,5,6,5,0),
  999)
  +
  (FLOOR(( Date_de_prise_en_charge__c - Date_de_reception__c )/7)*5)

This formula return the number of weekdays. I only miss obly saturday. I assume my error is on (MOD) operator.

Would you help me to solve this formula and explain to me ?

Thanks

Hi,

I am trying to create a formula fied which return number of days between two dates while excluding ONLY sundays.

I am trying with the formula below as base :
CASE(MOD( Date_de_reception__c - DATE(1985,6,24),7),
 
  0 , CASE( MOD( Date_de_prise_en_charge__c - Date_de_reception__c ,7),1,2,2,3,3,4,4,5,5,5,6,5,1),
  1 , CASE( MOD( Date_de_prise_en_charge__c - Date_de_reception__c ,7),1,2,2,3,3,4,4,4,5,4,6,5,1),
  2 , CASE( MOD( Date_de_prise_en_charge__c - Date_de_reception__c ,7),1,2,2,3,3,3,4,3,5,4,6,5,1),
  3 , CASE( MOD( Date_de_prise_en_charge__c - Date_de_reception__c ,7),1,2,2,2,3,2,4,3,5,4,6,5,1),
  4 , CASE( MOD( Date_de_prise_en_charge__c - Date_de_reception__c ,7),1,1,2,1,3,2,4,3,5,4,6,5,1),
  5 , CASE( MOD( Date_de_prise_en_charge__c - Date_de_reception__c ,7),1,0,2,1,3,2,4,3,5,4,6,5,0),
  6 , CASE( MOD( Date_de_prise_en_charge__c - Date_de_reception__c ,7),1,1,2,2,3,3,4,4,5,5,6,5,0),
  999)
  +
  (FLOOR(( Date_de_prise_en_charge__c - Date_de_reception__c )/7)*5)

This formula return the number of weekdays. I only miss obly saturday. I assume my error is on (MOD) operator.

Would you help me to solve this formula and explain to me ?

Thanks