I am a ship captain. Our crew works 28 days on, 28 days off. Payroll is every 14 days starting with the first Monday of the year. Our rotations are in the middle of the week mostly, and therefore in the middle of a pay period. I manually entered the "Days Pay". I have a formula to calculate the first monday of the year. The crew can enter their first rotation. I just need to be able to saw the "Days pay" accurately and dynamically.
| Pay Dates | Days Pay | Gross Pay |
| 1/5/2024 | 14 | $0 |
| 1/19/2024 | 3.5 | $0 |
| 2/2/2024 | 0 | $0 |
| 2/16/2024 | 10.5 | $0 |
| 3/1/2024 | 14 | $0 |
| 3/15/2024 | 3.5 | $0 |
| 3/29/2024 | 0 | $0 |
| 4/12/2024 | 10.5 | $0 |
| 4/26/2024 | 14 | $0 |
| 5/10/2024 | 3.5 | $0 |
| 5/24/2024 | 0 | $0 |
| 6/7/2024 | 10.5 | $0 |
| 6/21/2024 | 14 | $0 |
| 7/5/2024 | 3.5 | $0 |
| 7/19/2024 | 0 | $0 |
| 8/2/2024 | 10.5 | $0 |
| 8/16/2024 | 14 | $0 |
| 8/30/2024 | 3.5 | $0 |
| 9/13/2024 | 0 | $0 |
| 9/27/2024 | 10.5 | $0 |
| 10/11/2024 | 14 | $0 |
| 10/25/2024 | 3.5 | $0 |
| 11/8/2024 | 0 | $0 |
| 11/22/2024 | 10.5 | $0 |
| 12/6/2024 | 14 | $0 |
| 12/20/2024 | 3.5 | $0 |
| 1/3/2025 | 0 | $0 |
