Conditional formatting issue start and end dates

[Liverlee]

Hello, can someone help me with the conditional formatting formula for this Gantt chart. It's driving me up the wall.
I've 12 monthly dates formatted as mmm-yy they increment with edate formula.

I've tried this but it seems to start highlighting from January through to the correct end date
=AND($D6="T", OR(AND(INDEX($H$4:$S$4,1,COLUMN()-COLUMN($H$6)+1)=TEXT($E6,"mmm-yy"), INDEX($H$4:$S$76,MATCH($E6,$E$6:$E$76,0),COLUMN()-COLUMN($H$6)+1)<=$F6), AND(INDEX($H$4:$S$4,1,COLUMN()-COLUMN($H$6)+1)<=$F6, $E6<=$F6)), COLUMN()>=COLUMN($H6), COLUMN()<=COLUMN($S6))

and I've tried this =AND($E6="T", $F6<=INDEX($H$4:$ZL$4,1,COLUMN(F6)-COLUMN($F$6)+1), $G6>=INDEX($H$4:$ZL$4,1,COLUMN(F6)-COLUMN($F$6)+1)) some months it works for i.e if start and end date in the same month.

Pleeeeeeeeeeeeeease can someone save a soul and give me a solution.

 

[Fluff]

How about

=AND($D6="T",$E6<=H$4,$F6>=H$4)

 

[Liverlee]

it's almost perfect. For some reason, if it's a date that isn't the 1st jan or 1st feb like 15th Jan it won't pick up the jan but show feb-through to whatever end date.

I've put in 2 helper columns to pick up eomonth dates for the start and end dates to get the 1st of the month and will use your code with new helper columns in G and H.

Thankyou folks

 

[Fluff]

Ok, how about

=AND($D6="T",EOMONTH($E6,-1)<H$4,$F6>=H$4)

 

[Liverlee]

Fluff, you are the best

 

[Fluff]

You're welcome & thanks for the feedback.