Figure 1. Next Working Day in Excel.

If we are required to determine the next day if work or business, based on a specific date, we can achieve this by utilizing the Excel WORKDAY Function.

Generic Formula

=WORKDAY(date,1,holidays)

• date is the specific date from which we want to start counting.
• holidays is a range of holiday dates occurring in our search.

Taking into account weekends and holidays, the Excel WORKDAY Formula will automatically add days to our specified date.

How to use the Excel WORKDAY Function.

We are going demonstrate how to use the WORKDAY Function in 3 simple steps.

1. Enter all the dates available for counting as well as specified holiday dates, within columns of our worksheet.

Figure 2. Next Working Day in Excel.

2. In our worksheet example, we are going to enter the following WORKDAY formula into cell B2;

=WORKDAY(A2,1,C2:C7)

Figure 3. Next Working Day in Excel.

Our specified date from which the count begins is in A2, and our range of holiday dates is C2:C7.

3. Modify the WORKDAY Formula in B2, and copy down into the other cells in the NEXT WORKDAY column.

Figure 4. Next Working Day in Excel.

Note

The Excel WORKDAY Function only recognizes the actual holiday dates, rather than the holiday names.

Figure 5. Final Result.

Instant Connection to an Expert through our Excelchat Service:

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes.