Calculate the number of working days minus holidays (Canadian)
 

Hi there,

I'm trying to do a calculation with an order date and ship date but can't
get it to give me just the working days. Ideally I would like to exlclude
holdays as well if possible.

I know this is a tough one but any help would be greatly appreciated.

Tx

Suzanne

Calculate the number of working days minus holidays (Canadian)
 

In A1 thru A4:

12/9/2008
2/1/2009
12/25/2008
1/1/2009

In another cell:

=NETWORKDAYS(A1,A2,A3:A4)

Will give the working days between 12/9 and 2/1 with 12/25 & 1/1 as holidays
Make sure Analysis ToolPak is installed.
--
Gary''s Student - gsnu200819


"Grd" wrote:

Hi there,

I'm trying to do a calculation with an order date and ship date but can't
get it to give me just the working days. Ideally I would like to exlclude
holdays as well if possible.

I know this is a tough one but any help would be greatly appreciated.

Tx

Suzanne

Calculate the number of working days minus holidays (Canadian)
 

Excellent.

Works great. Had some trouble finding the ToolPak - it was under Tools,
Add-ins hiding away.

Tx again

"Gary''s Student" wrote:

In A1 thru A4:

12/9/2008
2/1/2009
12/25/2008
1/1/2009

In another cell:

=NETWORKDAYS(A1,A2,A3:A4)

Will give the working days between 12/9 and 2/1 with 12/25 & 1/1 as holidays
Make sure Analysis ToolPak is installed.
--
Gary''s Student - gsnu200819


"Grd" wrote:

Hi there,

I'm trying to do a calculation with an order date and ship date but can't
get it to give me just the working days. Ideally I would like to exlclude
holdays as well if possible.

I know this is a tough one but any help would be greatly appreciated.

Tx

Suzanne