Formula has to take Monday if due date falls on a Sunday

[Guest]

I have a large formula to calculate due date under different conditions.If
this due date is on a Saturday ,Sunday or on a holiday, it has to cconsider
Monday or next working day, as applicable.

 

[Bob Phillips]

=due_date+(WEEKDAY(due_date,2)>5)+(WEEKDAY(due_date,2)=6)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Ron Rosenfeld]

I have a large formula to calculate due date under different conditions.If
this due date is on a Saturday ,Sunday or on a holiday, it has to cconsider
Monday or next working day, as applicable.

With your list of holidays in holiday_range, try this formula:

=WORKDAY(your_formula - 1,1,holiday_range)

If the WORKDAY function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in.

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.


--ron