Was hoping someone can help me out!

I have spreadsheet (Excel 2010) - Where I have a start date in Column C, End Date Column D, and Salary in Column B. From Columns E onward I have Months listed - September, October, November etc.

I'd like Excel to populate the Months columns with salary information based on a start date. For example, if an employee worked for half of September, I'd like excel to recognize that and put half of the salary. From then onward, the rest of the months would be full salary. It doesn't have to be so specific with working days etc (For example, if a person joined on the 10th of september, They would then be entitled to 2/3 a months salary)... if that makes sense?

Then I'd like to have an end date as well!

Im a total beginner when it comes to macros and VBA stuff - So if you wouldnt mind walking me through how to do that (if thats part of the solution) i would be GREATLY APPRECIATIVE!

thanks