Business Days

Kerri55 · Apr 10th, 2002, 03:43 PM

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

Mark W. · Apr 10th, 2002, 03:45 PM

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

Kerri55 · Apr 10th, 2002, 04:13 PM

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

Mark W. · Apr 10th, 2002, 04:16 PM

Quote:

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 · Apr 11th, 2002, 08:09 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 03:43 PM	#1
Kerri55 New Member Join Date: Apr 2002 Posts: 4	I need to subtract one date from another, in business days only. (excluding weekends,holidays)

Apr 10th, 2002, 03:45 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	See the Excel Help topic for "NETWORKDAYS worksheet function".

Apr 10th, 2002, 04:13 PM	#3
Kerri55 New Member Join Date: Apr 2002 Posts: 4	I do not have function NETWORKDAYS available. I went to tools, data analysis to install, but it isn't there. What now?

Apr 11th, 2002, 08:09 AM	#5
Kerri55 New Member Join Date: Apr 2002 Posts: 4	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.