Networkdays Function
Networkdays Function
(OP)
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
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





RE: Networkdays Function
Stephen Argles
Land & Marine
www.landandmarine.com
RE: Networkdays Function
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).
RE: Networkdays Function
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: Eng-Tips.com Forum Policies
RE: Networkdays Function