Can't get excel formula correct

[NDCS_2022]

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)

https://youtu.be/tuQpGzL_14g

Help please!

[#2 · Accepted solution]

@NDCS_2022 

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)

[#3]

Thank you so much!!