Hello All,
This might be something really easy, but I seem to be struggling with this.
I need my formula column to output the due date - and should be the working day before the event date (delivery date).
That means, if the delivery date is Tuesday 13/1/26, Due Date Should be Monday 12/1/26.
If the delivery date is Monday 12/1/26, due date should be Friday, 9/1/26.
Even if the delivery date is a Sat or Sun, due date should be friday.
This is what I have so far:
IF(
WORKDAYS(SUBTRACT_DAYS({Delivery Date}, 1), SUBTRACT_DAYS({Delivery Date}, 1)) = 1,
SUBTRACT_DAYS({Delivery Date}, 1),
IF(
WORKDAYS(SUBTRACT_DAYS({Delivery Date}, 1), {Delivery Date}) = 1,
SUBTRACT_DAYS({Delivery Date}, 3),
SUBTRACT_DAYS({Delivery Date}, 2)
)
)
Can anyone please guide me on how to achieve this?