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

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.

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Revathi" <Revathi@discussions.microsoft.com> wrote in message
news:E4CDA3B7-31E6-46AE-AACA-049D82DD6BE2@microsoft.com...
> 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.

On Fri, 28 Apr 2006 02:21:02 -0700, Revathi <Revathi@discussions.microsoft.com>
wrote:

>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