Forum Discussion

tamara390's avatar
tamara390
Copper Contributor
Nov 28, 2021

Agile Gantt chart - removing weekend - PLEASE HELP!

I am trying to remove weekend from my agile gantt chart. I am using the excel template. I have searched the internet for about 2 hours and i cannot find a solution. Please help I am on a deadline.
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 29, 2021

tamara390 

I guess you may use WORKDAY() function. Here

In formula here

as

=IF(AND( $C14="Goal", I$7>=$F14, I$7 <= WORKDAY($F14, $G14)-1 ),2, IF(AND($C14="Milestone",I$7>=$F14, I$7 <= WORKDAY($F14, $G14) -1 ),1,""))

and in conditional formatting rule formula

  • CTyson's avatar
    CTyson
    Copper Contributor
    Jul 01, 2022

    Thanks a million. The formulas worked!!SergeiBaklan 

      • SHENRY625's avatar
        SHENRY625
        Copper Contributor
        Jun 20, 2024

        SergeiBaklan  Thank you for posting this. I too am looking to get a workday only chart, but I have added a column for an end date that would help show that relationship for an upcoming renovation schedule. 

         

        I also don't need the "Assigned to" or "Progress" or "Category", but i'm still having these problems. 

         

        Any help would be appreciated. 

         

         

         

  • hlokey's avatar
    hlokey
    Copper Contributor
    May 12, 2022

    SergeiBaklan 

     

    This is helpful (thanks for including the template) but I'd lactually like to see the weekends in the calendar but to have them not be colored for the task. So if a low-risk task lasts 10 days there would be 10 blue workdays and then the weekends that fall in the middle would either be white or some subtle color like grey to show that they are excluded from the task. 

     

    Also, would it be possible to have a column (maybe add right after G "days") where you can decide if the task will exclude weekends and then the conditioning will be based off of that?

     

    Thank you!

Resources