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

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

--
Kind regards,

Niek Otten

"Jfilbig" wrote in
message ...

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, 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" wrote in message
...
On 3 Feb 2006 10:10:10 -0800, 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" wrote:

To add days, use the WORKDAY function.



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