Go Back

Next working day

Read time: 20 minutes

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.

  1. 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.

  1. 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.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

Hi I am using today function in my cells.but next day it changes the date automatically. How do I lock the day
Solved by G. B. in 25 mins
I have a working formula that looks at 3 different cell values "Year" "Month" "Day" If "Day" cell = Select, Ignore "day" and show the combined total for "Year" and "Month" and ignore "Day" value
Solved by B. J. in 15 mins
Hi, I want to sum two column individually and divide them only for one day and then for the next day it continues like the same
Solved by C. A. in 11 mins

Leave a Comment

avatar