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

**AWilderbeast** · 08-31-2010, 05:33 AM

Hi all,

im tryign 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 do able?
Thanks

**estige** · 08-31-2010, 06:47 AM

Hi,
=NETWORKDAYS(A2;A1)
returns 52 workdays in the interval.

=NETWORKDAYS(A2;A1)/5
returns 10,40

Sure this isn't what you're looking for?

**DonkeyOte** · 08-31-2010, 09:04 AM

If the start date is exclusive of the calc then you should modify start date (or end date) accordingly given NETWORKDAYS is inclusive by nature:

=NETWORKDAYS(A2+1,A1)/5

would return 10.2 rather than 10.4

Prior to XL2007 the use of NETWORKDAYS requires activation of the Analysis ToolPak Add-In (tools -> addins)

note: delimiters differ pending your locale - this in unspecified - modify as required