Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Removing Saturday and Sunday from five day intervals

  1. #1
    Guest

    Default

    Help.

    I am tasked with calculating five working day intervals for start and end times, not including weekends.

    The start date may be a Monday, with the job due on a Friday - easy - five days total.

    The problem is when I get a start day on a Tuesday and then the finish day on the next Monday (the weekend days are included even though they don't really count as working days) the total days works out to seven (when in actual fact, the duration is five working days).

    How can I set this up so that the weekend days are omitted in my query?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try

    =NETWORKDAYS(A1,A2)

    where A1 = Start day
    and A2 = End day

    Inclusive

    Ian Mac

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •