Hello,
I am trying to find a formula that will calculate the number of missed pay periods for an unpaid window of time. We are paid in arrears on the 25th of the month for the 1st-15th and 10th of the following month for the 16th-end of the month. The formulas I have tried are capturing pay periods where the person would get a partial check.
For example:
Joe Smith
Unpaid Leave Start Date: 2/6/2024
Unpaid Leave End Date: 9/16/2024
Joe will receive a partial paycheck on 2/25 for any hours worked through 2/6. He will be unpaid for 14 pay periods and will not receive a paycheck until 10/10. My formulas incorrectly calculate that he is missing 15 pay periods. I've attached an example workbook.
Any help would be much appreciated!!
Bookmarks