Forum Discussion
normabeez
Apr 26, 2023Brass Contributor
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...
- Apr 26, 2023
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)
HansVogelaar
Apr 26, 2023MVP
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)
normabeez
Apr 26, 2023Brass Contributor
HansVogelaar thank you so very much! It worked perfectly. Have a great day!