Add or Subtract Working Days in Excel

A

alfa567

We need a formula in Excel to add or subtract working days. The current
formula "Networkdays" 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 "I
Agree" 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 "I Agree" in the message pane.

http://www.microsoft.com/office/com...9-c7521d236128&dg=microsoft.public.excel.misc
 
R

Ron Rosenfeld

We need a formula in Excel to add or subtract working days. The current
formula "Networkdays" 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 "I
Agree" 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 "I Agree" in the message pane.

http://www.microsoft.com/office/com...9-c7521d236128&dg=microsoft.public.excel.misc
Click to expand...

Since you are recommending that we all contact Microsoft about this "problem",
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 "working days" into the HELP bar and checked
out the WORKDAY function.
--ron
 
C

Chip Pearson

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.com
 
Top