Salary Phasing when taking in to account different options/dates/etc

Help! I am really struggling with a formula and know I probably just am sequencing something incorrectly. I have a spreadsheet where I have all the FTE's in my group listed out, a drop down box for whether they are "Active" or "Termed" or "Transferred". I then have a column for hire date, term date and transfer date. Then a column for each month labeled, 1/31/15, 2/28/15, etc, etc etc. Any help with this formula? Salary is Column Q, Position Stats Dropdown is column V, Hire date column W, Transfer date column X, And then I have the 12 columns for the phasing. So I need to be able to prorate if someone is hired mid year, if someone is here and than termed or transferred, etc. Any help is much appreciated! Thx

Please post a sample file with examples of expected results (for various scenarios).

File with the 3 scenarios i would encounter are attached.

You need to explain (to me at least!) the business logic and how the various dates fit in re the states "Active", "Termed" and "Transferred"

As far as i could see, only the date in W is referenced in the formulae in AC onwards EXCEPT AD which has a different formula to the rest and references the date in X.

The formulas are not right - those are the formulas I am struggling with - hence missing or wrong or not consistent as I have been playing with various scenarios.

Logic is I have over 500 employees. I want to be able to make changes on the fly to their status - new hire, term or transferred out and ahve the salary amount for the given month in which the hire date, term or transfer was impacted and have that populate correctly in the monthly columns. And that feeds directly in to another forecast model. Does that explain this more?