Calculate the number of working days minus holidays (Canadian)

G

Grd

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
 
G

Grd

Excellent.

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

Tx again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using project as a resource tracker 0
Calculating calendar days excluding holidays 3
Calculating days spent to complete a task 2
number of months and days between two dates without approximation 3
formula to calculate # of days between dates, excluding holidays 8
Level resource allocation error 1
calculate time elapsed inbetween days 3
Adding days to the WORKDAY function 2

Top