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?