function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
T-HanT-Han 

Formula to calculate SUM of variable NUMBER of DAYS and a DATE to get a DATE without Weekend.

Hi Y'all..

 

Need F1(help.. :))..

 

F1 = Date Field without weekends.

F2 = Custom Formula Field (number)

F3 = Date Field

 

I need to calculate:

 

F1 = F2+F3, but I should not get dates with Weekends.

 

This is my Previous code with standard number of days, this time its variable number based on a field.

 

CASE(MOD((RFP_Review_Start_Date__c ) - DATE(1900, 1, 7) , 7),
0, F3+1,
1, F3+1,
2, F3+1,
3, F3+1,
4, F3+1,
5, F3+3,
6, F3+2,
null)

 

Need assistance in this please. Please let me know if any further things needed..

 

 

DataRecoveryNederlandDataRecoveryNederland

explained a bit in another topic but ill put it here to, maybe it will help other users.

 

http://boards.developerforce.com/t5/Formulas-Validation-Rules/Formula-without-weekends/td-p/555643/page/2