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...
egspen2 wrote: ``a partial month salary if the start or end date indicate an employee was not there for the full month [....] should only get 23/31 days of salary``
Are you sure about that?
Most employees do not work every day of the month, but they are still given full-month credit.
Or is this a class exercise, and the rules do not have to make sense?
Even so, I wonder if the exercise expects you to prorate based on NETWORKDAYS, at the very least.
Fair question but in this instance I'm calculating for salaried employees, not hourly. So, even though I don't actually work 30 or 31 days in a month, I'm paid for that amount of days. Is your comment re: "NETWORKDAYS" speaking to an Excel function?