Networkdays Function 1

[JPM73]

Hi Excel Users,

I'm attempting to use the networkdays function in Excel 2003. For some reason, it's not calculating correctly.

For Example:

Cell Value Comment
A1 04/18/08 Start Date
A2 04/22/08 Deliver or End Date
A3 04/21/08 Holiday - even though there's no real
holiday on this day

If my start date is 04/18 & my Delivery or End Date is 04/22, then I should see a result of 1 day.

This is suppose to exclude weekends & the holiday.

I have the formula as follows:

=(NETWORKDAYS(A1,A2,$A$3)

Even when I put in my End Date as 04/18, I am getting a result of '1' day, instead of '0' days.

Am I missing something or not inserting this formula properly or Excel 2003 not work well for this function?

Thanks

Jason,
CTQ Engineering
Technical Team Leader
GE Product Definition Designer

 

[StephenA]

Surely the 18th is a work day by itself, therefore 18th plus 22nd is two days, although the Excel description does say "between these dates" which could be argued to exclude both of them.

Stephen Argles
Land & Marine

http://www.landandmarine.com

 

[rb1957]

i'd interpret 18th to 22nd as you're going to start at the beginning of the 18th and deliver at the end of the 22nd, so there are 5 days available, with 19 and 20 being non-work days therefore 3 work-days (2 if you include your "holiday")

from this i think the function is returning the number of days between the start and end dates +1 (accounting for the start and end days, presumably being partial days).

 

[IRstuff]

The function isn't a timer function, i.e., it doesn't keep track of fractions of days. Reading the help entry, it specifically talks about using the function for determining acrual of employee benefits, which is only base on calendar days of work.

This means that the function simply takes the difference of the serial number of the starting day and the serial number of the ending day plus 1. It's NOT intended for figuring out anything related to actual work.

You can verify this by putting in the time, like 4/18 11:59 PM for start and stop, and the function still returns 1 day

TTFN

FAQ731-376

 

[cvg]

it sounds like you are attempting to do project scheduling with excel. You might be better off spending just a bit of $ to get Microsoft Project, Primavera or similar scheduling software which can do everything you need, a lot better than excel without spending time trying to write the equations.