Formula for identifying if date(s) fall within a range of dates (Gantt Chart/Cond. Format)

I'm trying to create a gantt chart for project tasks that will essentially be a visual of the project schedule based on start and end dates. I need the chart to display based on weeks rather than days - with the first monday of each week as the timeline basis. I've created the below chart with and IF AND formula and conditional formatting, and it works for the most part but seems to be having issues when the start and end date is the same day. Basically what I need this to do is reflect a colored cell within each week shown across the top if the task falls within that week based on the start and end dates. Thoughts on how to modify my formula?
Here's what I've been using: =IF(AND(G$7>=$D8,G$7<=$E8),"X","")

Capture.PNG

Hi and welcome

Any chance you could attach the file (a desensitized copy if necessary) rather than a pic of it? Easy to help if we can work with the real thing.

BSB

try this:

Please Login or Register  to view this content.

I think this did it! Thanks so much for the quick reply!