Date Diff - excluding working days
 

Hi all, Does anyone know how i can return the difference between two dates
that across weeks, months and years and only count working days?

Date Diff - excluding working days
 

Use NETWORKDAYS, that is exactly what it is for.

--

HTH

Bob

"Scott_goddard" wrote in message
...
Hi all, Does anyone know how i can return the difference between two
dates
that across weeks, months and years and only count working days?

Date Diff - excluding working days
 

You will want to use the NETWORKDAYS function... if you are using XL2007 or
later, this function is built into Excel... if you are using XL2003 or
earlier, you need to activate the Analysis ToolPak add-in (Click
Tools/Add-Ins on the Excel menu bar).

--
Rick (MVP - Excel)



"Scott_goddard" wrote in message
...
Hi all, Does anyone know how i can return the difference between two
dates
that across weeks, months and years and only count working days?