formula needed for prorating annual salary

Hi everyone,
I need some assistance in coming up with a formula to prorate salaries for 2017.
Start date will be their hire date is in Column C (this can go back to 1/1/17) and the end date will be 1/8/18.
Column E is annual salary and Column H is increase amount. However, the increase for those hired in 2017 will not be the full amount but a prorated amount based on hire date.
Hope all that made sense.
Thanks in advance for any assistance!

Ostensibly, enter the following into I2 (Excel automatically propagates down the column):

Please Login or Register  to view this content.

Note that that is the prorated annual increase. Append +E2 if you want the projected salary.

The rounding ensures that the prorated annual increase is a multiple of the periodic wage increase (biweekly or hourly).

The formula assumes that the hire date is 1/1/2017 or later, as stated.

To avoid binary arithmetic anomalies, you might wrap the entire formula with ROUND, to wit:

Please Login or Register  to view this content.