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

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
LVL 1
###### Who is Participating?

Microsoft MVP ExcelCommented:
correct the cell references in the above formula to

=NETWORKDAYS(A2,A1)/5

The syntax for Networkdays() is

=Networkdays(startDate,endDate,[holidays - optional])
0

Microsoft MVP ExcelCommented:
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
0

Author Commented:
it comes out as -10.4 on mine, why -?
0

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

Commented:
format the cell as number with decimal place Zero.
0

Author Commented:
thats great thanks
0

Microsoft MVP ExcelCommented:
>> it comes out as -10.4 on mine, why -?

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