Calculating difference between working days?

[mccrimmon]

Hi

Im looking for a function to calculate the difference between two dates, which excludes Saturday & Sunday.

Can anyone help?

Thanks

McCrimmon

[oldchippy]

You need the NETWORKDAYS function, but you will need to load the Analysis Tool Pak for this one

=NETWORKDAYS(StartDate,EndDate,Holidays)

[Jazzer]

Or like this with "traditional" functions:

=B2-A2-2*INT((B2-A2+WEEKDAY(A2,3))/7)-MAX(0,WEEKDAY(B2,3)-4)

A2 = start date, B2 = end date.

- Asser

[daddylonglegs]

Networkdays counts both the start and end date so if start is today (Thursday) and end is tomorrow (Friday) it'll give 2. Assuming that A2 and B2 are both weekdays Jazzer's formula will give 1 less, i.e. for my example above the result would be 1.

You can do that also with this formula

=B2-A2-SUM(INT((WEEKDAY(A2-{1,7})+B2-A2)/7))