Trevor3007
Well-known Member
- Joined
- Jan 26, 2017
- Messages
- 667
- Office Version
- 365
- Platform
- Windows
Hi ,
I currently use :-
=NETWORKDAYS.INTL(A2,B2,1,C2:D2)
but how do I include dates that are in col: H?
For example:-
(A2)start date (b2) end date Total days worked (h2)Absences
13/1/20 7/2/20 16 15/1/20
21/1/20
2/2/20
3/2/20
Hoping this males sense?
KR
Trevor3007
I currently use :-
=NETWORKDAYS.INTL(A2,B2,1,C2:D2)
but how do I include dates that are in col: H?
For example:-
(A2)start date (b2) end date Total days worked (h2)Absences
13/1/20 7/2/20 16 15/1/20
21/1/20
2/2/20
3/2/20
Hoping this males sense?
KR
Trevor3007