date (minus) date = working days diff

[jjj]

Hello All,

Quick and easy one (I hope), i have two dates how can i work out the working days between them ?


Kind Regards
JJJ

[Niek Otten]

Use the NETWORKDAYS() function
If you get a #NAME error: Tools>Add-ins, check Analysis Toolpak

--
Kind regards,

Niek Otten

"jjj" <[email protected]> wrote in message
news:[email protected]...
>
> Hello All,
>
> Quick and easy one (I hope), i have two dates how can i work out the
> working days between them ?
>
>
> Kind Regards
> JJJ
>
>
> --
> jjj
> ------------------------------------------------------------------------
> jjj's Profile:
> http://www.excelforum.com/member.php...fo&userid=7424
> View this thread: http://www.excelforum.com/showthread...hreadid=490742
>

[Roger Govier]

Hi

Try =NETWORKDAYS(firstdate,seconddate,holidays)

Networkdays is part on the Analysis Toolpak so go to Tools>Addins> and
ensure Analysis Toolpak is selected.

Substitute the cell reference holding your earliest date for firstdate, and
the cell ref for your latest date fro seconddate.
Holidays is either a list of cells containing public holidays, or a named
range containing the holiday dates.

Regards

Roger Govier


jjj wrote:
> Hello All,
>
> Quick and easy one (I hope), i have two dates how can i work out the
> working days between them ?
>
>
> Kind Regards
> JJJ
>
>

[JE McGimpsey]

Check out the NETWORKDAYS() function in XL Help. Note that it's an
Analysis Toolpak Add-in function (Tools/Add-ins...)

In article <[email protected]>,
jjj <[email protected]> wrote:

> Hello All,
>
> Quick and easy one (I hope), i have two dates how can i work out the
> working days between them ?
>
>
> Kind Regards
> JJJ