Calculate Number of Days Between Dates Minus Weekends

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to calculate the number of days between two given dates minus the
weekends. Is there a formula that does this?
 
I am trying to calculate the number of days between two given dates minus the
weekends. Is there a formula that does this?
Click to expand...


Look in HELP for NETWORKDAYS. You will need to have the Analysis ToolPak
installed. The directions to do that are with the Networkdays HELP screen.
--ron
 
That's it. Thanks Ron.

Ron Rosenfeld said:
Look in HELP for NETWORKDAYS. You will need to have the Analysis ToolPak
installed. The directions to do that are with the Networkdays HELP screen.
--ron
Click to expand...
 

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

How to calculate the number of days between two dates 2
Creating and transit time excel formula 4
Template for calculating different number of days between 2 dates 1
Calculation between 2 date? 3
Calculate number of WEEKENDS between two dates? 3
Calculate times between dates and times in Excel 1
Date Formula Excluding Weekends 3
time interval between dates incl weekends excl holidays 7

Back
Top