Forum Discussion

normabeez's avatar
normabeez
Brass Contributor
Apr 26, 2023

Gantt Chart Calendar Population Not Working Correctly

Hi All,   Another Gantt Chart question for everyone. I am working off the Agile Gantt Chart template and have made some modifications. Long story short, I am trying to have the calendar portion ref...
  • HansVogelaar's avatar
    Apr 26, 2023

    normabeez 

    You mix adding a number of calendar days and adding a number of working days.

    The formula in J11 should be

     

    =IF(AND($C11="Goal",J$7>=$F11,J$7<$G11),2,IF(AND($C11="Milestone",J$7>=$F11,J$7<$G11),1,""))

     

    Fill to the right, then down (or vice versa)

Resources