wrightyrx7
11-07-2012, 07:53 AM
Hi all,
I have a calculator i want to build in excel but what i want it to do is the following:-
It will have a "Start Date", "End Date", "Annual Salary", "Monthly Salary" - this data will be input manually.
Pay for a "full month" is Annual Salary / 12
Pay for part month is "monthly salary" / total network/working days in the given month * number of network/working days from date given to the end of the month,
E.g "20/11/2012" - "10/01/2013", "£365", "£30.42"
First part of example would be to calculate pay for November 12.
£30.42 / 22 (network days in November) * 9 (network days from 20/11/2012 - 30/11/2012) = £12.44
Second part of example add salary for FULL MONTHS
In example there is only 1 full month - December 12 = £30.42
Third part of example would be to calculate pay for January 13
£30.42 / 23 (network days in January) * 8 (network days between 01/01/2013 - 10/01/2013) = £10.58
So overall the Total pay would be £12.44 + £30.42 + £10.58 = £53.44
Hope this makes sense. Can anyone please help?
Regards
Chris
I have a calculator i want to build in excel but what i want it to do is the following:-
It will have a "Start Date", "End Date", "Annual Salary", "Monthly Salary" - this data will be input manually.
Pay for a "full month" is Annual Salary / 12
Pay for part month is "monthly salary" / total network/working days in the given month * number of network/working days from date given to the end of the month,
E.g "20/11/2012" - "10/01/2013", "£365", "£30.42"
First part of example would be to calculate pay for November 12.
£30.42 / 22 (network days in November) * 9 (network days from 20/11/2012 - 30/11/2012) = £12.44
Second part of example add salary for FULL MONTHS
In example there is only 1 full month - December 12 = £30.42
Third part of example would be to calculate pay for January 13
£30.42 / 23 (network days in January) * 8 (network days between 01/01/2013 - 10/01/2013) = £10.58
So overall the Total pay would be £12.44 + £30.42 + £10.58 = £53.44
Hope this makes sense. Can anyone please help?
Regards
Chris