Counting Network days

[Corleone]

Just trying to work out how to dothe following example

In cell a1 I have inputted to date 05/apr/04
in cell b1 i have 10
in cell c1 I need the date to be A1 + 10 days based on networkdays
(ie ignoring weekends)
how do I do this?

thanks

 

[Aladin Akyurek]

=WORKDAY(A1,B1)

If you also want to exclude the holiday dates and such...

=WORKDAY(A1,B1,Exclude)

where Exclude refers to a range housing holiday dates.

 

[Corleone]

Hi thanks for the quick response
tried this and just got the error message below

#NAME?

Is this because the workday function is not available in excel 2000
which is what I am using


thanks

 

[fairwinds]

"If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu."

 

[Corleone]

Thanks guys