Gantt Chart Calendar Population Not Working Correctly

[normabeez]

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!

[#2 · Accepted solution]

@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)

[#3]

@Hans Vogelaar thank you so very much! It worked perfectly. Have a great day!