Working Days

G

Guest

Hi, Please help...

I am trying to workout the number of working days between to dates.

I have a column of paperworkrecieveddate (28-Jun-06) and second column with
VisitDate(24-Jun-06)
The answer would be 3 but how would I get this answer?

Thanks,
Jez
 
G

Guest

Use the NETWORKDAYS function

ex

Cell A1 = 6/24/06
Cell A2 = 6/28/06

cell B1 =NETWORKDAYS(A1,A2)

The function also accomodates holidays. The help file is useful for a more
complete explanation.

HTH
JonR
 
B

Bearacade

use networkdays function.

Must have Analysis Toolpak enabled

and you should put in holidays as your argument
 

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

month gaps counting through whole column 14
Hello I am trying to write an If/Then statement. Here is the data. 2
match one column with dates to several colums with dates, copy pas 4
Need help with lookup & sum range 2
AutoFill the data 1
Supressing a #VALUE! error returned? 3
Summing weekly values to fall into correct month 2
finding duplicates 4

Top