I have another board with a “Live Date” column and “Final to Marketing” column using the code below (Subtracting 1). However, if you choose a Sunday (Live Date) it still returns a Saturday date in the Final to Marketing column instead of pushing it to Friday. It works if I pick Monday, it pushes it back to Friday. I think I’m missing something.
FORMAT_DATE(
SUBTRACT_DAYS(
{Live Date},
SUM(
1,
IF(
MOD(
1,
5
)
>
WEEKDAY({Live Date})-1,
2,
0
),
ROUNDDOWN(
1/5,
0
)*2
)
),
“ddd MMM DD”
)