MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formula to exclude weekend days ?


Posted by Rick M on February 19, 2001 12:36 PM

I need a formula to determine the number of days it took to service an account.


Posted by Aladin Akyurek on February 19, 2001 1:18 PM

Did you try the function NETWORKDAYS(startdate,enddate)? If you don't have it on your system, have a look at Contents and Index under Help. It's explained there what you need.

Aladin


Aladin

Posted by Rick M on February 19, 2001 1:53 PM

The dates are in a cell. example:
A1 = 1/31/2001
B1 = 2/7/2001
I tried the formula =networkdays(a1,b1)
the result is #name?
What am I doing wrong????

Posted by Aladin Akyurek on February 19, 2001 2:09 PM

Go to Tools, Adds in and select Analysis ToolPak. Without this add-in Excel does not recognize the function.

Aladin