software

We need a formula in Excel to add or subtract working days. The current
formula quot;Networkdaysquot; is not sufficient.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc

On Sun, 19 Mar 2006 19:11:26 -0800, alfa567 gt;
wrote:

gt;We need a formula in Excel to add or subtract working days. The current
gt;formula quot;Networkdaysquot; is not sufficient.
gt;
gt;----------------
gt;This post is a suggestion for Microsoft, and Microsoft responds to the
gt;suggestions with the most votes. To vote for this suggestion, click the quot;I
gt;Agreequot; button in the message pane. If you do not see the button, follow this
gt;link to open the suggestion in the Microsoft Web-based Newsreader and then
gt;click quot;I Agreequot; in the message pane.
gt;
gt;www.microsoft.com/office/comm...lic.excel.misc

Since you are recommending that we all contact Microsoft about this quot;problemquot;,
perhaps you could tell us what you think the problem is with the function that
already exists to add or subtract working days.

I presume you typed something like quot;working daysquot; into the HELP bar and checked
out the WORKDAY function.
--ron

The NETWORK days determines the number of working days between
two dates. It does not add or subtract dates. You are using the
wrong function. Instead, use the WORKDAY function.

=WORKDAY(TODAY(),3)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;alfa567quot; gt; wrote in message
...
gt; We need a formula in Excel to add or subtract working days. The
gt; current
gt; formula quot;Networkdaysquot; is not sufficient.
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds
gt; to the
gt; suggestions with the most votes. To vote for this suggestion,
gt; click the quot;I
gt; Agreequot; button in the message pane. If you do not see the
gt; button, follow this
gt; link to open the suggestion in the Microsoft Web-based
gt; Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc