Gantt-like Chart Based on Dates and Percentage

Hi,

I'm trying to create an automated gantt chart that takes into account dates and %.
The formula I've come up with works fine, except it doesn't capture when mid-week arrival/departures >> =IF(AND($A5<=D$1,$B5>=D$2),$C5,"")

Column A: Arrival Date
Column B: Departure Date
Column C: %

Row 1: Date (Week Starting)
Row 2: Date (Week Ending)


In the document attached, I've manually input the values I would expect to see in red based on the dates/% entered to the left.

Any ideas how I could fold both dates and % into mid-week values would be greatly appreciated!

Thanks!

You are correct -- my mistake! It should be 0.14

Thank you so much! Works perfectly!

You're welcome! And thanks for marking your thread Solved.

If this helped, consider clicking on addreputationiconsmall.jpg below.