Results 1 to 2 of 2

Thread: Scheduling in Excel
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2010
    Posts
    104
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Scheduling in Excel

    I need to create a gantt chart that will draw horizontal bars when I enter start and finish dates.

    The user would enter the item description, start date, and duration (in work days).

    Questions:
    - To get the finish date...I add the duration to the start date. How do I format the resulting finish date so that it does not calculate the weekends as part of the duration?
    - Is there an easy chart type in Excel that can draw the bars and create timeline?

  2. #2
    Board Regular RasGhul's Avatar
    Join Date
    Jul 2016
    Posts
    586
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Scheduling in Excel

    I would use the =NETWORKDAYS(startdate,enddate,[Holidays]) function to filter workdays.

    There are plenty of decent youtube videos on gantt charts if you look around.

    - forum use guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

Some videos you may like

User Tag List

Tags for this Thread

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
  •