Need to populate columns (salary information) based on start date and end date!

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

Hello twhippse24,

Please find attached a file with a possible solution. You have to adapt it to your real situation tough.

I oftenly use value codes in dates to count the days within a formula but there is probably a dozen ways easier than that one - I'm sure.

If you require further assistance please let me know.
Additionally if someone can provide a smoother way (formula) to reach the same result, even better


Kind Regards,
FCarv