Add condition to Networkdays formula

[Gijs]

The formula I’ve been successfully using to determine the number of weekend days and public holidays of a project, is:
=M13-NETWORKDAYS(K13,L13,'2018 Public holidays'!$C$1:$C$11)
(M13 is the total number of days between K13, the start date and L13 the end date, '2018 Public holidays'!$C$1:$C$11 is the list of public holidays)

This works perfect for one country. In the same formula, I now need to apply the same principle for different countries, based on the public holidays across different countries.

For each row/project, I’ve put the name of the country (USA or UK) in column H and in tab '2018 Public holidays' I’ve the list of public holidays for both countries and added in column '2018 Public holidays'A:A, USA or UK to identify each country’s public holiday date.

How do I add the criteria of column H with the condition of column '2018 Public holidays'A:A into the formula?

Thanks in advance!

 

[Tetra201]

Is this what you need?

=M13-NETWORKDAYS(K13,L13,IF('2018 Public holidays'!$A$1:$A$11=H13,'2018 Public holidays'!$C$1:$C$11,))

Note: this is an array formula -- it has to be entered using Ctrl+Shift+Enter, not just Enter.

 

[Gijs]

Hugely appreciated. Works like a charm! Thanks, have a great day

 

[Tetra201]

You are welcome.