We want to find the number of workdays between the start date and end date with the holiday as non-working days. In the cell where you want to place the result type: =NETWORKDAYS(A2, B2, H2 ) ...