Hi,
Trying to calculate number of workdays (M-F) between two dates, where someone is employed for a max of 4 days per week.
So, for example, if contract period were 1st April 2020 to 28th April 2020:
- First week is Wed 1st. Thurs 2nd and Fri 3rd Apr, so would only be able to work 3 days only that week.
- Week 2-4 would be 4 days each week as they are full weeks
- Week Five of Mon 27 Apr and Tue 28 Apr, would be 2 days only.
So total days if max of 4 per week is 17.
Hoping someone can help
Thanks
Trying to calculate number of workdays (M-F) between two dates, where someone is employed for a max of 4 days per week.
So, for example, if contract period were 1st April 2020 to 28th April 2020:
- First week is Wed 1st. Thurs 2nd and Fri 3rd Apr, so would only be able to work 3 days only that week.
- Week 2-4 would be 4 days each week as they are full weeks
- Week Five of Mon 27 Apr and Tue 28 Apr, would be 2 days only.
So total days if max of 4 per week is 17.
Hoping someone can help
Thanks