Forum Discussion
Calculate partial month salary
Thank you! A few questions:
1) can you confirm that "$M4" at the end of your example should actually be "$M28"?
2) When I copy that formula to an example of a person whose end date is in the next year (2023 in this case), the only 2022 month that's showing up properly is the first month. See below where after July, the monthly amounts being calculated are greater than the 2022 Monthly salary. What part of the formula is causing this?
1) Yes - $M4 was a typo.
2) Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
Sample attached with 3 different scenarios (employees).
First is an employee who should have the same value in every month ($13,750) as they are expected to be here July through December.
Second is an employee leaving in July, mid-month so should have less than the monthly amount ($9,785) in July and $0 for each remaining month.
Third is an employee that should have partial salary in July as they are starting mid-month but should have the same full month for each month of Aug - December.
Thank. See the attached version.
