CurrentHamster
New Member
- Joined
- Dec 10, 2018
- Messages
- 4
Good Afternoon,
I'm trying to find a formula that will count the number of working days per month between two dates.
I can do the number of working days per month between two dates (If "End Date is blank it calculates using the last day of the current month):
Formula in C2:
=IF($B2="",NETWORKDAYS($A2,EOMONTH(TODAY(),0)),NETWORKDAYS($A2,$B2))
<tbody>
</tbody>
I can also do the number of days per month betwen two dates:
<tbody>
</tbody>=MAX(0,MIN(IF($b2="",TODAY(),$b2),EOMONTH(DATEVALUE(D$1),0))-MAX($A2,DATEVALUE(D$1))+1)
But I can't seem to combine the two together so that e.g. E3 should be 5 because the Sat 4th and Sun 5th, I don't need to exclude Bank Holidays just weekends.
I'm trying to find a formula that will count the number of working days per month between two dates.
I can do the number of working days per month between two dates (If "End Date is blank it calculates using the last day of the current month):
Formula in C2:
=IF($B2="",NETWORKDAYS($A2,EOMONTH(TODAY(),0)),NETWORKDAYS($A2,$B2))
A | B | C | |
1 | Start Date | End Date | Full Time Equivalent |
2 | 03/12/2018 | 02/01/2019 | 23 |
3 | 05/12/2018 | 07/01/2019 | 24 |
4 | 29/11/2018 | 197 |
<tbody>
</tbody>
I can also do the number of days per month betwen two dates:
A | B | C | D | E | |
1 | Start Date | End Date | Full Time Equivalent | Dec-18 | Jan-18 |
2 | 03/12/2018 | 02/01/2019 | 23 | 29 | 2 |
3 | 05/12/2018 | 07/01/2019 | 24 | 27 | 7 |
4 | 29/11/2018 | 197 | 31 | 31 |
<tbody>
</tbody>
But I can't seem to combine the two together so that e.g. E3 should be 5 because the Sat 4th and Sun 5th, I don't need to exclude Bank Holidays just weekends.