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.