+ Reply to Thread
Results 1 to 5 of 5

Gantt Chart Formula to remove weekdays

  1. #1
    Registered User
    Join Date
    01-31-2020
    Location
    London
    MS-Off Ver
    10
    Posts
    3

    Gantt Chart Formula to remove weekdays

    Hello

    I am currently using the below formula in my gantt chart however want to only display Mon-Fri. Please could you advise what I should do?

    =Project_Start-WEEKDAY(Project_Start,1)+2+7*(Display_Week-1)

    Thanks

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,210

    Re: Gantt Chart Formula to remove weekdays

    I would advise attaching a sample as it is hard to see what you want. follow the instruction on the yellow bar

    Also look at the workday and workday.intl functions they may help with what you want to do, I use them on my Gantt charts

  3. #3
    Registered User
    Join Date
    01-31-2020
    Location
    London
    MS-Off Ver
    10
    Posts
    3

    Re: Gantt Chart Formula to remove weekdays

    Hello
    Please see attached
    Attachment 660816

    Thanks for your help

  4. #4
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,210

    Re: Gantt Chart Formula to remove weekdays

    I for one will not open links unless they are attached as per the yellow bar. My browser will not follow your link

  5. #5
    Registered User
    Join Date
    01-31-2020
    Location
    London
    MS-Off Ver
    10
    Posts
    3

    Re: Gantt Chart Formula to remove weekdays

    My browser wont allow me to attach to this website but thanks anyway

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Remove weekends from a gantt chart
    By JNEWMAN in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-07-2019, 09:19 AM
  2. [SOLVED] Have the ability to view a daily Gantt chart as a monthly gantt chart
    By adam_d_john in forum Excel General
    Replies: 3
    Last Post: 03-13-2018, 09:11 PM
  3. Gantt Equation: Weekdays Only with Project duration issues.
    By skyping in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-19-2015, 06:54 AM
  4. Replies: 5
    Last Post: 10-04-2012, 07:01 AM
  5. Replies: 0
    Last Post: 07-13-2012, 06:40 PM
  6. formula for gantt chart
    By sanlen in forum Excel General
    Replies: 1
    Last Post: 08-31-2010, 08:53 AM
  7. Remove extra vertical space in Gantt chart
    By run4it in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-03-2009, 06:57 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1