Forum Discussion
Solved
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 reflect the start and end dates correctly. Some work as they should, some do not although the formulas appear to be the exact same.
I have reviewed this looking at the formula view trying to identify what the discrepancy might be but have been unsuccessful. I checked the conditional formatting as well with no luck identifying the problem. If anyone could kindly review and see what I might have done wrong, it would be most appreciated!
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)
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 thank you so very much! It worked perfectly. Have a great day!
