Spreadsheet guide
Excel WORKDAY Formula
How to use Excel WORKDAY to add business days and exclude holidays.
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.