+ Start a Discussion

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,


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




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