Finding Working Days
Key points
- Choose WORKDAY
- Enter the days
- Enter holidays
In Date Offset Builder, WORKDAY gives the date some working days later, skipping weekends.
Steps
- Choose WORKDAY
- Enter the days
- Enter holidays
Enter a holiday range to skip holidays too.
Use "Build a Date Offset Formula" (free)
Tools that go well with this
- Calculate Age, Days Between Dates and Date Offsets: Calculate age and days between dates.
- Build a DATEDIF Formula: Build a DATEDIF formula.
- Excel Serial Number and Date Converter: Convert Excel serial numbers and dates.