Can't get excel formula correct

New Contributor

I'm trying to follow the below youtube tutorial on creating a Gantt chart in excel, but am stuck on the formula detailed at minute 12:30. This is what I have and it looks right when I compare to the formula in the video, but no matter what I try, it's not working: =AND($16>0, K$4 <= ($E6+($F6-$E6)*$16)-WEEKDAY(($E6+($F6-$E6)*$16),2)+1, K$4 >= $E6 - WEEKDAY($E6, 2)+1)


Help please!

⭐️⭐️⭐️ GET THIS TEMPLATE PLUS 52 MORE here: 👍 Ready made and ready to use. How to make the absolute BEST weekly Gantt Chart in Excel, that looks like Microsoft Project and is easier and better to use! Your managers
2 Replies
best response confirmed by NDCS_2022 (New Contributor)


It's not $16 but $I6 with upper case i after the $ sign:


=AND($I6>0, K$4 <= ($E6+($F6-$E6)*$I6)-WEEKDAY(($E6+($F6-$E6)*$I6),2)+1, K$4 >= $E6 - WEEKDAY($E6, 2)+1)

Thank you so much!!