Forum Discussion
Calculate partial month salary
I am trying to figure out the best formula that will calculate either a) a full month of salary or b) a partial month salary if the start or end date indicate an employee was not there for the full m...
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.