Next business day
IntermediateIn accounting, invoices often need to be routed for approval and entered into the system on a business day (not weekends or company holidays).
The WORKDAY function returns a date that’s a given number of workdays before/after a start date. You can also provide a list of holidays to skip.
What you need to do:
- In cell C2, calculate the next business day after the invoice date in B2.
- Exclude the holiday dates listed in B13:B15.
- Fill the formula down through C10.
Tip: Lock the holiday range with $ so it doesn’t shift when you fill down. In this spreadsheet, dates may display as serial numbers, that’s OK.
Need some help?
Hint 1
WORKDAY takes a start date, a number of workdays, and an optional holiday range.
Hint 2
You want the next business day, so the workdays argument should be 1.
Hint 3
Make the holiday list absolute (like $B$13:$B$15) before filling the formula down.
Related function(s)
Answer
Exercise
Next business day
IntermediateIn accounting, invoices often need to be routed for approval and entered into the system on a business day (not weekends or company holidays).
The WORKDAY function returns a date that’s a given number of workdays before/after a start date. You can also provide a list of holidays to skip.
What you need to do:
- In cell C2, calculate the next business day after the invoice date in B2.
- Exclude the holiday dates listed in B13:B15.
- Fill the formula down through C10.
Tip: Lock the holiday range with $ so it doesn’t shift when you fill down. In this spreadsheet, dates may display as serial numbers, that’s OK.
Need some help?
Hint 1
WORKDAY takes a start date, a number of workdays, and an optional holiday range.
Hint 2
You want the next business day, so the workdays argument should be 1.
Hint 3
Make the holiday list absolute (like $B$13:$B$15) before filling the formula down.