Workdays between two dates

[hamburg18w]

I am using excel 2003 (win) and want to calculate how many workdays after due date a particular report is turned in. I am using NETWORKDAYS function but it gives me the wrong number of days. The following example illustrates my dilema:
=networkdays(a4,a5) where a4 equals 5/3/10 and a5 equals 5/5/10. This formula returns a 3 and I would think that it should return a two. Can someone help me with this issue?

Thank you!
Juan

 

[GlennUK]

There are 3 working days in the date range that you gave. If I started work on the 5/3/10 and finished on 5/5/10 I'd have worked 3 days .... the function gives the number of working days in the range, inclusive of the start and end dates. If you want to know the difference in working days between 2 dates simply subtract 1 from the result.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[mintjulep]

If you want to know the difference in working days between 2 dates simply subtract 1 from the result.

I think that won't work if the start or end date is NOT a work day.

 

[strongm]

However, adding one to the start date or subtracting one from the finish date will work, whether start or end dates are work days or not.

And given that the OP is asking how to calulate "how many workdays after due date a particular report is turned in" I'm guessing that the start date they quote is actually the date the report was due in, so we can work with Start Date + 1 to meet the requirement.

=NETWORKDAYS(a4 +1, a5)

 

[Gruuuu]

so, instead, add 1 to the start day.

 

[GlennUK]

Thanks mintjulep, strongm, and Gruuuu. I didn't spot that weakness in my suggestion.

Cheers, Glenn.

Beauty is in the eye of the beerholder.