How to Add Business Days in Excel?
Add Business Days to Date is a Excel function that calculates the date that is 10 business days from today, excluding weekends.. Formula Genius generates and validates this formula automatically from a plain-English prompt.
Need to find a future date while skipping weekends and holidays? This formula will help you calculate business days easily.
The Formula
"Find the date that is exactly 10 business days from today, skipping weekends and holidays"
=WORKDAY(TODAY(), 10)This formula calculates the date that is 10 business days from today, excluding weekends.
Step-by-Step Breakdown
- TODAY() returns the current date.
- WORKDAY function adds a specified number of business days to a date.
- The second argument (10) specifies the number of business days to add.
- Weekends are automatically excluded from the calculation.
Edge Cases & Warnings
- If today is a Friday, the result will skip Saturday and Sunday.
- If there are holidays within the 10 business days, they will also be skipped.
- If the start date is a holiday, the calculation will begin from the next business day.
Examples
"Today is March 1, 2023"
March 15, 2023"Today is December 20, 2023"
January 3, 2024Frequently Asked Questions
What if I want to include holidays?
You can use the WORKDAY.INTL function to specify holidays.
Can I change the number of business days?
Yes, simply replace '10' with your desired number of business days.
Does this work for dates in the past?
No, WORKDAY only calculates future business days from the given date.
Can't find what you need?
Describe any formula in plain English and Formula Genius will generate, explain, and validate it — instantly.