Formula help: Duration Without Weekend Days

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

Hi, I'd like to compute the duration of a series of tasks by subtracting the
end date from the start date--but also removing the weekend days to give an
accurate 'days' count. Thanks in advance for your replies, JP
 
You simply need to use the worksheet function, "networkdays", you can get
more details from the help file on this function.
 
It sounds like you want to use =networkdays()

If you're using xl2003 or below, you'll have to have the analysis toolpak
loaded. Excel's help for =networkdays() will show you how.
 
Thanks, JH - but it looks like my version of Excel doesn't include this handy
function, unless I missed something.

I use 2003 SP3 - is there an alternate way of doing this?

Thanks again,
JP
 
Did you look up "networkdays" in Excel help, as JH suggested? What did it
tell you? Why do you think that you don't have the function?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates 4
End Date Calculation (adding a start date duration) 5
day of the week and date formula 2
Subtracting number of days excluding the weekend 2
time interval between dates incl weekends excl holidays 7
Syntax-evaluate (enddate - duration = startdate) 2
Count days without weekends 2
Formula to Remove Weekend Days 1

Back
Top