+ Reply to Thread
Results 1 to 4 of 4

Gantt Chart CF Cells Based on Start and End Days in Data BUT Exclude Weekends

  1. #1
    Registered User
    Join Date
    06-01-2022
    Location
    Orlando, FL
    MS-Off Ver
    365
    Posts
    7

    Gantt Chart CF Cells Based on Start and End Days in Data BUT Exclude Weekends

    Hello All -

    Attached is my attempt at customizing a Simple Gantt Chart.

    I have the Start and End Days for a project. I am experiencing issues adjusting the conditional formatting to exclude Sat and Sun.

    Additionally, I would like to integrate a cell on each project line to choose whether or not to include just Saturday in the CF shading.

    It's for landscaping projects, and rain days happen.

    Thanks in advance.

    -steve
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: Gantt Chart CF Cells Based on Start and End Days in Data BUT Exclude Weekends

    Not sure which CF you need to ignore Weekends on...
    Assuming it's the blue one.
    Formula should be...
    Please Login or Register  to view this content.
    Weekday(date,2) will return 1 to 5 for Mon to Fri. So if 6 or 7 is returned, it's Sat, Sun.

    To include Sat for project line. Can be tricky. If project line spans more than one Sat, does it include both? Or just one?

    If project line never spans 2 Sat... you can add condition like... (use whatever cell that you'd use to include Sat, instead of $M8).
    Please Login or Register  to view this content.
    "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    06-01-2022
    Location
    Orlando, FL
    MS-Off Ver
    365
    Posts
    7

    Re: Gantt Chart CF Cells Based on Start and End Days in Data BUT Exclude Weekends

    Hello CK - Thanks for your reply.

    But...

    It is not working on my end. It is filling in the Saturday.

    I edited the Rule for the Blue Fill (you were correct) and the result is not correct.

    I also cleaned up my Start and End Date Calculations and I do not understand why this update affects the Rule as it does.

    The attached sheet is with these changes.

    Thanks again!!
    Attached Files Attached Files

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: Gantt Chart CF Cells Based on Start and End Days in Data BUT Exclude Weekends

    I am confused. Your Saturdays are not filled when I open your file.

    Attachment 845736
    Attached Images Attached Images

+ 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. Replies: 1
    Last Post: 12-12-2022, 05:33 PM
  2. Adapt Gantt chart to exclude weekends
    By daniamalik in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-06-2021, 04:56 PM
  3. [SOLVED] auto-populate gantt chart visuals based on start & end
    By canadianjameson in forum Excel General
    Replies: 4
    Last Post: 04-08-2020, 09:30 PM
  4. Adding working days on weekends to a gantt chart
    By Yannis07 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2020, 08:19 AM
  5. Exclude weekends in a Gantt chart
    By bobelmore in forum Excel General
    Replies: 2
    Last Post: 10-18-2019, 04:44 PM
  6. [SOLVED] Gantt conditional formatting to exclude weekends?
    By rarerollingobject in forum Excel General
    Replies: 12
    Last Post: 02-01-2019, 04:17 PM
  7. Replies: 7
    Last Post: 03-07-2018, 03:10 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