Help! Counting Sick Working Days Formula?

[Crab]

I'm just having no luck trying to get this calculation to work... and
I'm sure it'll probably be fairly basic.

Basically I'm trying to count the number of working days someone has
been off work sick. (Monday to Friday and not counting Saturday or
Sunday).

I have the first day of absence in DDMMYY in one column (D3) and then
todays date in E3 (using the =NOW() function). But whenever I try to
use the Network days function, which I saw recommended on
dailydoseofexcel.com, i.e. =NETWORKDAYS(D3,E3) , I just get a #NAME?
error.
If I do Insert > Name > Define and put Networkdays, I get a #REF!
error.

I am using Excel 2000. Any help would be greatly appreciated!

Many thanks.

 

[Bernd P]

Hello,

goto Tools / Add-ins.. and tick the box next to Analysis ToolPak.

Or take my formula solution (if you do not have any bank holidays to
consider):
http://www.sulprobil.com/html/date_formulas.html

Regards,
Bernd

 

[Guest]

hi
networkdays is part of the analysis toolpack. if you are getting the #name
error then you don't have it installed. it's an add in that should have come
with your xl install disc. if not then see this site and down load the xl
function dictionary. i think it has the toolpack with it.
www.xlfdic.com
regards
FSt1

 

[Guest]

You need to go to Tools->Add-ins and check the Analysis Toolpak add-in.

 

[Roger Govier]

Hi

Networkkdays is part of the Analysis Toolpak.
Tolls>Addins>check Analysis Toolpak

 

[Crab]

Hi

Networkkdays is part of the Analysis Toolpak.
Tolls>Addins>check Analysis Toolpak

That did the trick! - a million thanks to you all )