Create a type of psuedo gantt chart

[ddander54]

I'd like to create a 'pseudo' gantt chart of sorts

My Project data is on Columns A:U, TimelineDates start in Column V, Column A is the Project number and is always a number, never blank or NULL, There are 2 header lines, so the Project data starts in row A3.

Proj.....StartDate.......Duration........Hours........|.1/1/2018...2/1/2018...3/1/2018...4/1/2018..5/1/2018...etc
1.........1/1/2018.......2..................21.............|
1.........2/1/2018.......2..................11.............|
1.........2/1/2018.......3..................30.............|

Result
Proj.....StartDate.......Duration........Hours........|.1/1/2018...2/1/2018...3/1/2018...4/1/2018...5/1/2018...etc
1.........1/1/2018.......2..................21.............|....21...........21
1.........2/1/2018.......2..................11.............|...................11.............11
1.........2/1/2018.......3..................30.............|...................30.............30.............30

I started with this formula (=IF(V$2=$S3, $U3, ""), where Column V$2 is the TimelineMonth, $S3 is the StartDate, and $U3 is the Hours), but it only applies the duration to the first cell where the Timelinedate match StartDate....which makes sense.
Is there a way to modify the formula to incorporate the duration into the formula so the hours stretch across the duration in the Timeline?
Or is this better left to VBA? If VBA, what would that look like?

Thanks in Advance,
Don