Calculating No of Days between 2 dates INCLUDING Weekends but EXCLUDING Public Holidays

[excelnoob1991]

Hi all,

I've tried different approaches and done my research but most of them exclude both weekends and public holidays.

However, I would like to calculate how many days of Hospitalisation Leave were used from 31 Oct 2023 to 19 Dec 2023.
Include Weekends, Exclude Public Holiday

E17: 31 October 2023
F17: 19 December 2023
The Public Holiday data is in another sheet.

Thank you.

 

[Peter_SSs]

The Public Holiday data is in another sheet.

Assuming that is in A2:A19 of Sheet2 try

=NETWORKDAYS.INTL(E17,F17,"0000000",Sheet2!A2:A19)