Spreadsheet guide
Google Sheets Business Days Formula
How to calculate business days in Google Sheets using WORKDAY and NETWORKDAYS.
Quick formula
=WORKDAY(start_date, days, holidays)
Use a start date, the number of business days to add, and an optional holiday range. For counting business days between two dates, use NETWORKDAYS.
Example
If A2 contains a start date and E2:E20 contains bank holidays, =WORKDAY(A2,10,E2:E20) returns the date 10 working days later.