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

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

use networkdays function.

Must have Analysis Toolpak enabled

and you should put in holidays as your argument


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=556662