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
"Jez" wrote:

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