Excluding Friday & Saturday from the calculation

O

Omar

Dear all,
I have the following data:
Starting date= 01/04/2010, dd/mm/yyyy format
Ending date= 26/04/2010, dd/mm/yyyy format.
I want to get the difference, ending date-starting date, but I need
the result without Friday & Saturday, how to exclude Friday & Saturday
from the calculation?
Many thanks in advance.
Omar.
 
P

Pete_UK

Take a look at the NETWORKDAYS function in Excel Help. It is built-in
for XL2007, but for earlier versions you will have to install the
Analysis ToolPak.

Hope this helps.

Pete
 

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

Top