<div>
Hello awilderbeast,<br />
<br />
you can use Networkdays() to use only weekdays and exclude weekdays and holidays. In Excel 2003 and earlier, you need to activate the Analysis Toolpak<br />
<br />
With your data, the formula would be<br />
<br />
=NETWORKDAYS(A6,A3)/5<br />
<br />
You want to divide by 5, since that is the number of workdays in the week. The result is 10.4, though, not 10.2<br />
<br />
cheers, teylyn
</div>


Hello awilderbeast,

you can use Networkdays() to use only weekdays and exclude weekdays and holidays. In Excel 2003 and earlier, you need to activate the Analysis Toolpak

With your data, the formula would be

=NETWORKDAYS(A6,A3)/5

You want to divide by 5, since that is the number of workdays in the week. The result is 10.4, though, not 10.2

cheers, teylyn

<div>
it comes out as -10.4 on mine, why -?
</div>


<div>
try to use networkdays function if you are using Excel 2007.
</div>


try to use networkdays function if you are using Excel 2007.

<div>
format the cell as number with decimal place Zero.
</div>


format the cell as number with decimal place Zero.

<div>
&gt;&gt; it comes out as -10.4 on mine, why -?<br />
<br />
NZ variance maybe. Things are different Down under. :-)<br />
<br />
Glad it works for you, and thanks for the grade.
</div>


>> it comes out as -10.4 on mine, why -?

NZ variance maybe. Things are different Down under. :-)

Glad it works for you, and thanks for the grade.

<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
im trying to get the difference between two dates in working weeks (5 day weeks)<br />
<br />
eg<br />
A1<br />
28/10/2011<br />
<br />
A2<br />
18/08/2011<br />
<br />
=(A1-A2)/7 give us 10.14 which is wrong for what we need, we need it to be a 5 day week not 7 so should give us 10.2<br />
<br />
this doable?<br />
Thanks
</div>
</div>


Hi all,

im trying to get the difference between two dates in working weeks (5 day weeks)

eg
A1
28/10/2011

A2
18/08/2011

=(A1-A2)/7 give us 10.14 which is wrong for what we need, we need it to be a 5 day week not 7 so should give us 10.2

this doable?
Thanks

Excel difference between two dates in working (5 day weeks)

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.