Here is what I am trying to accomplish:
For employees who were hired during 2020, forecast how much salary they are missing in their YTD salary number. Example: If they were hired 2/1/2020, they would have missed 2 pay periods, the partial adjustment would need to be 2* the current month salary.
So far I have that part figured out. I simply calculate the number of pay periods are between the first pay period in 2020, in our case it is 1/9/2020 and their start date. The issue becomes, what if they were hired 1 week in to the pay period, say 1/16/2020 with the next payroll being 1/23/2020. This is where I can really use some suggestions on how to sharpen my formula. I am thinking that I need to get the percentage of the pay period they are hired in, but not sure how to put that into effect.
Attached is what I have so far
Many thanks!
Bookmarks