Help! Counting Sick Working Days Formula?
 

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.

Help! Counting Sick Working Days Formula?
 

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

Help! Counting Sick Working Days Formula?
 

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

"Crab" wrote:

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.

Help! Counting Sick Working Days Formula?
 

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

"Crab" wrote:

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.

Help! Counting Sick Working Days Formula?
 

Hi

Networkkdays is part of the Analysis Toolpak.
TollsAddinscheck Analysis Toolpak

--
Regards
Roger Govier



"Crab" wrote in message
ups.com...
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.

Help! Counting Sick Working Days Formula?
 

On 9 Nov, 13:26, "Roger Govier" <rogerattechnology4NOSPAMu.co.uk
wrote:
Hi

Networkkdays is part of the Analysis Toolpak.
TollsAddinscheck Analysis Toolpak

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