Quick answer
Count or add business days in Google Sheets using NETWORKDAYS and WORKDAY.
=NETWORKDAYS(A2,B2,holidays)=WORKDAY(A2,10,holidays)
When to use this formula
Use it when you need a repeatable spreadsheet calculation for invoice due dates, project plans, payroll checks, support SLAs, or other weekday-based deadlines.
Common checks
- Make sure your date cells are real dates, not text.
- Keep public holidays in a separate list.
- Confirm whether the start date should count.
Need a quick answer without spreadsheet setup?
FAQs
Does Google Sheets support NETWORKDAYS?
Yes. NETWORKDAYS works in Google Sheets.
Can Google Sheets exclude holidays?
Yes, provide a holiday date range as an extra argument.
Which formula adds business days?
Use WORKDAY to add business days to a date.