Need a way to split effort across weeks

hello all,
i am new here.. posting my first question here..

I have a requirement wherein i need to split the number of days worked for person based on the start and end dates of his work allocation.
This split needs to be done across columns labelled with dates falling on every wednesday. The effort filled needs to consider only the weekdays.

I have attached a sample sheet on how i want the columns to be populated based on the start and end dates.
Any help is appreciated... thanks.