Script to auto fill cells based on multiple criteria.

See my attached workbook. I need a code that can take the value in Resource Detail:Col A and copy it into each column, starting with the start date through and including the end date which is listed in Resource Detail:Col C and D. So for row 5, it would copy 1.50 to every column from 8/17 to 6/30 which can be found in Row 2. I would also like a way for it to skip columns that are either Sat or Sun (row 1).