×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Networkdays Function

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

Jason,
CTQ Engineering
Technical Team Leader
GE Product Definition Designer

RE: Networkdays Function

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
www.landandmarine.com

RE: Networkdays Function

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).

RE: Networkdays Function

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: Eng-Tips.com Forum Policies

RE: Networkdays Function

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.   

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources