Use the stated workday proration policy, not a calendar-day assumption. This arithmetic exercise does not decide whether an exempt salary deduction is legally permitted.
Read the case before entering a formula. The workbook separates input amounts from the result so a reviewer can trace your calculation. Use references rather than typing the displayed total. A hidden copy changes the inputs and checks that your approach still works. Compare the result with the stated period and wage base, then examine any cap or zero balance. A blank cell and a zero result mean different things. Keep the sign on reconciliation differences so another reviewer can tell whether the register is higher or lower.
Use the stated workday proration policy, not a calendar-day assumption. This arithmetic exercise does not decide whether an exempt salary deduction is legally permitted.