date range

Posted by Dayle on August 04, 2001 6:33 AM

I know how to subtract one date from another date to find the exact number of days. However, is there a way to find the exact number of business days between the two dates?
Thanks!

Posted by Mark W. on August 04, 2001 7:01 AM

Use the NETWORKDAYS() function. If this function
is not available, run the Setup program to install
the Analysis ToolPak. After you install the Analysis
ToolPak, you must enable it by using the Add-Ins
command on the Tools menu.