Pro-rata value based on 2 dates

Hi Jenna,

The question is clear however just need the following answered

Are they only being charged for the working days in that period or the total amount of days passed between those two dates?

Thank you for your question posted in STL's forum Jenna.

You want to calculate a pro rata charge based on a start and finish date

The first thing to do is to determine the daily rate for the year.
If the yearly rate is 200 then the daily rate would be 200/365.

The next thing to determine is the amount of days that have expired between the start date and the finish date that the employee was assigned to the scheme. To determine that you can simply subtract the start date from the finish date:

[=Cell containing the finish Date - Cell containing the start date]

You can now multiply the number of days expired and the daily rate which should now give you the total rate for the period.

I have attached an Excel workbook with 2 solutions:
Solution1 has the different calculations in separate columns to get to the end result

Solution2 Has the pro rata calculation in one cell by combining the different steps into one calculation.

I hope this helps you.