Business Days

[Kerri55]

I need to subtract one date from another, in business days only.
(excluding weekends,holidays)

 

[Mark W.]

See the Excel Help topic for "NETWORKDAYS worksheet function".

 

[Kerri55]

I do not have function NETWORKDAYS available. I went to tools, data analysis to install, but it isn't there. What now?

 

[Mark W.]

On 2002-04-10 15:13, Kerri55 wrote:
I do not have function NETWORKDAYS available. I went to tools, data analysis to install, but it isn't there. What now?

Go to Tools | Add-Ins...

Is there an entry in the list for Analysis ToolPak? If so, check it and press [ OK ].
This message was edited by Mark W. on 2002-04-10 15:17

 

[Kerri55]

I have access to the function. It wasn't in the tools, add in, analysis toolpack. I typed NETWORKDAYS, then selected the function button, and presto! Thanks for your help Mark.