determine workdays

  • Thread starter Thread starter Joe H.
  • Start date Start date
J

Joe H.

i am trying to calculate how many days between 2 dates that excludes
holidays and weekends. Is there a formula for that. Thanks,
 
Look at excel's help for =networkdays().

If you're using xl2003 and below, you'll have to have the analysis toolpak
loaded.

Tools|Addins check analysis toolpak

Depending on how excel was installed, you may need the distribution disks.
 
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

Date Calculation Formula- Calendar days minus Holidays 1
Alternative formula to exclude holiday calculation 6
Calculate next workday after adding calendar days to date in cell 13
Calculate workdays for irregular work patterns 1
How to calculate the number of Workdays for irregular work pattern 1
Workday function question 2
How do I calculate future date after number of days 1
Calculate the number of days to exclude Sunday & Holidays 6

Back
Top