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?

Use NETWORKDAYS, that is exactly what it is for.

--

HTH

Bob

"Scott_goddard" <(E-Mail Removed)> wrote in message
news:A3A21833-39E3-4E05-86E0-(E-Mail Removed)...
> 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?

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" <(E-Mail Removed)> wrote in message
news:A3A21833-39E3-4E05-86E0-(E-Mail Removed)...
> 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?