Calculating no of work days between two dates

  • Thread starter Thread starter fluffywhitedoh
  • Start date Start date
F

fluffywhitedoh

Please advise how to calculate the number of work days (excludin
weekeends and holidays) between two date
 
=NETWORKDAYS(start_date,end_date,holidays)

holidays is a range of holiday dates.

You will need to have the Analysis Toolpak installed, Tools>Addins, and
cheek it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"fluffywhitedoh"
 
You must log in or register to reply here.

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

hours/month excluding weekends (10hr) 5
Adding days to the WORKDAY function 1
days between dates 3
Excel Microsoft excel interest formula 2
calculate day using date 3
How many days 3
Expanding Date formula 1
How to calculate the number of days between two dates 2

Back
Top