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
PadtalluriPadtalluri 

Formula field is returning for all record types created date + 3 working days , please help for the below formula

I have written the below formula field to  add the number of working days to the created date for diffrent record types , but it is adding 3 business days to all scenarios.

IF(RecordType.DeveloperName ="Request_for_Data",CASE( 
MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ), 
3, CreatedDate + 2 + 3, 
4, CreatedDate + 2 + 3, 
5, CreatedDate + 2 + 3, 
6, CreatedDate + 1 + 3, 
CreatedDate + 3), 
IF(RecordType.DeveloperName ="Network_Information_Request", CASE( 
MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ), 
3, CreatedDate + 2 + 3, 
4, CreatedDate + 2 + 3, 
5, CreatedDate + 2 + 3, 
6, CreatedDate + 1 + 3, 
CreatedDate + 6), 
IF(RecordType.DeveloperName ="Network_Analysis_Request", CASE( 
MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ), 
3, CreatedDate + 2 + 3, 
4, CreatedDate + 2 + 3, 
5, CreatedDate + 2 + 3, 
6, CreatedDate + 1 + 3, 
CreatedDate + 8), 
IF(RecordType.DeveloperName ="Network_Analsysis_Adding_New_Employees_Divisions", CASE( 
MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ), 
3, CreatedDate + 2 + 3, 
4, CreatedDate + 2 + 3, 
5, CreatedDate + 2 + 3, 
6, CreatedDate + 1 + 3, 
CreatedDate + 8), 
IF(RecordType.DeveloperName = "Network_Options_Due_to_Provider_Termination", 
CASE( 
MOD(DATEVALUE(CreatedDate) - DATE( 1900, 1, 7 ), 7 ), 
3, CreatedDate + 2 + 3, 
4, CreatedDate + 2 + 3, 
5, CreatedDate + 2 + 3, 
6, CreatedDate + 1 + 3, 
CreatedDate + 8),null)