formula field

IF( /* If CreatedDate falls on Saturday (6) or Sunday (0) */ OR( MOD(DATEVALUE(CreatedDate) - DATE(1900, 1, 7), 7) = 6, MOD(DATEVALUE(CreatedDate) - DATE(1900, 1, 7), 7) = 0 ), /* Weekend: Start on Monday 00:00, then add 24 hrs = Tuesday 00:00 */ DATETIMEVALUE( TEXT(YEAR(DATEVALUE(CreatedDate) + 2)) & "-" & TEXT(MONTH(DATEVALUE(CreatedDate) + 2)) & "-" & TEXT(DAY(DATEVALUE(CreatedDate) + 2)) & " 00:00:00" ), /* If Friday (5) and CreatedDate + 24h lands on Saturday */ IF( AND( MOD(DATEVALUE(CreatedDate) - DATE(1900, 1, 7), 7) = 5, (VALUE(MID(TEXT(CreatedDate), 12, 2)) + 24) > 24 ), /* Move to Monday + remaining time */ DATETIMEVALUE( TEXT(YEAR(DATEVALUE(CreatedDate) + 3)) & "-" & TEXT(MONTH(DATEVALUE(CreatedDate) + 3)) & "-" & TEXT(DAY(DATEVALUE(CreatedDate) + 3)) & " " & TEXT(VALUE(MID(TEXT(CreatedDate), 12, 2)) + 24 - 24) & ":00:00" ), /* Else: Just add 1 day (24 hrs) */ CreatedDate + 1 ) )