Due date excluding weekend days

Need formula to add 3, 5 or 20 days to a start date and exlude sat sun.
Help please

Look at the WORKDAY() function, which does just that.
If you get a #NAME error: Tools>Add-ins, check Analysis Toolpak

--
Kind regards,

Niek Otten

"Jfilbig" <[email protected]> wrote in
message news:[email protected]...
>
> Need formula to add 3, 5 or 20 days to a start date and exlude sat
> sun.
> Help please
>
>
> --
> Jfilbig
> ------------------------------------------------------------------------
> Jfilbig's Profile:
> http://www.excelforum.com/member.php...o&userid=31156
> View this thread: http://www.excelforum.com/showthread...hreadid=508185
>

Or maybe: Look at NETWORKDAYS () which excludes weekends and andy
defined holidays.

Hans

On 3 Feb 2006 10:10:10 -0800, [email protected] wrote:

>Or maybe: Look at NETWORKDAYS () which excludes weekends and andy
>defined holidays.
>
>Hans

How do you use NETWORKDAYS to add 10 days to a given date?


--ron

To add days, use the WORKDAY function.


"Ron Rosenfeld" <[email protected]> wrote in message
news:[email protected]...
> On 3 Feb 2006 10:10:10 -0800, [email protected] wrote:
>
>>Or maybe: Look at NETWORKDAYS () which excludes weekends and
>>andy
>>defined holidays.
>>
>>Hans
>
> How do you use NETWORKDAYS to add 10 days to a given date?
>
>
> --ron

On Sun, 5 Feb 2006 09:03:26 -0600, "Chip Pearson" <[email protected]> wrote:

>To add days, use the WORKDAY function.
>
>

I know that. I was wondering why Hans was recommending the NETWORKDAYS
function.
--ron