dont include dates adb

[Trevor3007]

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

 

[GlennUK]

What is in C2:D2?

 

[Trevor3007]

What is in C2:D2?

hi glen,

so sorry for the delay getting back to you and many thanks for your reply too BTW.

I need to look at the issue again ....I respond so as.

KR
Trevor3007