Calculate Number of Days Between Dates Minus Weekends

M

Melissa

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
 
M

Melissa

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...
 
Top