Push to next working day

i have a formula like this

LEFT(FORMAT_DATE(ADD_DAYS(TODAY(), DIVIDE({Remaining time},8))),6)
which is nothing if but , it will calculate the new delivery date from by adding , remaning number days to “TODAY”.
now if the result is SAT or SUN , i want it to be on monday.
and second question ,
if the result date falls under list of given dates(public holidays) it should move to the next working day.
above second question is not mandatory or urgent

@karges

For you first question… Here is one way:

FORMAT_DATE(ADD_DAYS(TODAY(), DIVIDE({Remaining Time}, 8 ) + SWITCH(FORMAT_DATE(ADD_DAYS(TODAY(), DIVIDE({Remaining Time}, 8)), "E"), "6", 2, "7", 1, 0)), "MMM D")

Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday Formulas - Part 3: Dates/Times, Strings and Status

@karges

… the REAL solution:

FORMAT_DATE(WORKDAY(TODAY(), DIVIDE({Remaining time}, 8), ARGS2ARRAY("2021/12/24", "2021/12/31")), "MMM DD")

Of course, you can adjust the holidays however you want.

Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday Formulas: the SECRET Functions