NETWORKDAYS Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can find the work days between two dates using =NETWORKDAYS(A1,B1) but how
do I subtract a number of work days from a given date? (If I know when the
project must finish and the number of days it will take, When should I start?)
 
I can find the work days between two dates using =NETWORKDAYS(A1,B1) but how
do I subtract a number of work days from a given date? (If I know when the
project must finish and the number of days it will take, When should I start?)
Click to expand...

Look at the WORKDAY function
--ron
 
Ron,

I hope you can help me with this: there is no formula 'NETWORKDAYS' in my
Excel 2003. How can I have it in mine?

- Mike
 
It sounds as if you do not have the Analysis Toolpak addin installed. Go to
Tools>Addins and check that addin.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
From Excel's help for Networkdays:

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

Tools|Addins should get you close, but help will explain it in more detail.
 
Ron,

I hope you can help me with this: there is no formula 'NETWORKDAYS' in my
Excel 2003. How can I have it in mine?

- Mike
Click to expand...

What Bob and Dave wrote ...
--ron
 
Back
Top