Creating a bar chart from scratch

To explain what I am trying to do, I have a list of start and end dates in seperate cells on the left side of the sheet with dates running from left to right on the top of the sheet. I am trying to create a formula that will match my start and end dates on the left and put a predetermined input in every cell on that row that corresponds to the range of cells within the start and end date. Attached is a picture of what I am trying to accomplish that may explain better since I am self taught in excel. I do not need the colors in the formula cause I have that already taken care of.