Why you need this
Returns a date N working days in the future, excluding weekends and optional holidays. Essential for project management.
One-Click Copy
=WORKDAY(start_date, days, [holidays])
Copy
Quick context
- • Works in both Excel and Google Sheets.
- • Use when you need consistent, auditable results.
- • Copy the snippet above and adjust only the ranges.
When to use
Learn how to use the Excel WORKDAY Formula.
Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.
Common Mistakes
- ✕ Forgetting the holiday list. Without a range of holiday dates, the function assumes only weekends are non-working days.
Best Practices
- ✓ Keep a 'Holidays' sheet. Maintain a central list of company holidays and name the range 'CompanyHolidays' to use in all your project timeline formulas.