Formula to calculate number of weekdays between 2 dates

[dpaton05]

What is the formula to calculate the number of weekdays between 2 dates. I need it to not include public holidays, for instance, if I had a start date of 22/12/19 with a finish date of 26/12/19 (5 day period), I need the formula to return 3 weekdays, not 5 days as the 22nd is a sunday and the 25th is a public holiday.

• Start date is in B13
• Finish date is in B14
• There is a range of public holidays in G87:DO97

 

[mabbutt]

Have a look here

 

[dpaton05]

Thanks for that. I had a read and wasn't sure I could apply it to my situation.

 

[krykm]

That formula doesn't count saturdays. If only sundays are off change 1 to 11 in the formula.

=NETWORKDAYS.INTL(B13,B14,1,G87:DO97)

 

[dpaton05]

Thanks, that was perfect