Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Re-posted due to unanswered question

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dear Mr Excel

    I have created a Gantt chart in Excel as indicated in ‘tip of the week’ however I have utilised days instead of years as my unit of measure. I have also included an extra column which shows the number of days between the start and end date and an extra row which displays the approprite day.

    However I wish to exclude certain days of the week in this calculation i.e. Saturdays and Sundays (Non Working days). Therefore how can this be achieved?

    I presume the conditional formating will not help in this situation and the weekday function only provides numbers 1 to 7.

    Is there a formula that can do this, failing that will, a macro be required?

    Regards

    Anthony Quigley

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Use the NETWORKDAYS worksheet function. Take a look at the help topic for this function.

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
  •