networkdays not functioning correctly please help

**jtmayo** · 12-07-2012, 07:48 PM

Hello, I'm trying to calculate the number of week days a project is either delayed or ahead of schedule
Here is a example:
Commit date is Friday 11/21/2012 and the actual completion date is Monday 11/24/2012. The net delay should be +1
Commit date is Monday 11/24/2012 and the actual completion date is Friday 11/21/2012. The net delay should be -1

The formula I'm using is the following:
=NETWORKDAYS(commit date,completion date)

But when i use this function the returned number is either +3 or -3 in stead of +1 or -1, Somehow even using the networkdays function excel is still calculating the weekend.

What am i doing wrong, can anyone help me fix this?
I'm using Excel 2007

Joe

**Moo the Dog** · 12-07-2012, 08:04 PM

Well, considering 11/21/2012 was a Wednesday and the 24th was a Saturday - it seems alright to me.

- Moo

**jtmayo** · 12-07-2012, 08:09 PM

Sorry for the confusion should of been December not November. still not working right

**jtmayo** · 12-07-2012, 08:18 PM

Let me further explain with real examples, see image uploaded

sheet1.jpg

**daddylonglegs** · 12-07-2012, 08:21 PM

NETWORKDAYS won't count the weekend days but it does count both start and end date, try this version to get the result you want

=NETWORKDAYS(A2,B2)-SIGN(NETWORKDAYS(A2,B2))