Prev: stock control template
Next: vlook up w- multiple variables
From: Scott_goddard on 13 Apr 2010 11:32
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?
From: Bob Phillips on 13 Apr 2010 11:44
Use NETWORKDAYS, that is exactly what it is for.

--

HTH

Bob

"Scott_goddard" <Scottgoddard(a)discussions.microsoft.com> wrote in message
news:A3A21833-39E3-4E05-86E0-6B771E102908(a)microsoft.com...
> 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?


From: Rick Rothstein on 13 Apr 2010 11:53
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" <Scottgoddard(a)discussions.microsoft.com> wrote in message
news:A3A21833-39E3-4E05-86E0-6B771E102908(a)microsoft.com...
> 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?

 | 
Pages: 1
Prev: stock control template
Next: vlook up w- multiple variables