Revised - What formula can I use to find pay factors based on contract start and end date?

[Henry_Falcon77]

Hello everyone,

I would like a formula to display pay factors, weekends excluded. Example- Contract start date is 8/31 and end date is 10/25/22. Based off our pay calendar, the first pay would be for 7 days in pay #19 and 2 days in pay #23. I would like the formula result to show 3.9 pay factors if i typed in a start and end date (7 days in pay 19, 10 days in 20, 10 days in 21, 10 days in 22, and 2 days in 23). It would be awesome if i can get to display total factor of 3.9 plus a breakdown to display 2 days in pay 19. 10 in 20, 10 in 21, 10 in 22, and 2 in 23)

 

[Henry_Falcon77]

Hello everyone,

I would like a formula to display pay factors, weekends excluded. Example- Contract start date is 8/31 and end date is 10/25/22. Based off our pay calendar, the first pay would be for 7 days in pay #19 and 2 days in pay #23. I would like the formula result to show 3.9 pay factors if i typed in a start and end date (7 days in pay 19, 10 days in 20, 10 days in 21, 10 days in 22, and 2 days in 23). It would be awesome if i can get to display total factor of 3.9 plus a breakdown to display 2 days in pay 19. 10 in 20, 10 in 21, 10 in 22, and 2 in 23)



View attachment 72024

 

[Henry_Falcon77]

I know I can use =(NETWORKDAYS(StartDate1,EndDate1,0Holidays)/10) to find total pay factors. I just didn't know if there was a way to match it with my pay calendar. For example, I would like it to display .7 or 7 day pay for start date and 2 day or .2 for end date based on our payroll calendar.