Calculate Number of Days Between Dates Minus Weekends

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?
 
R

Ron Rosenfeld

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
 
G

Guest

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
Template for calculating different number of days between 2 dates 1
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Diff in business days 2
Calculate number of WEEKENDS between two dates? 3
Date Formula Excluding Weekends 3
Creating and transit time excel formula 4
Expanding Date formula 1

Top