Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles DATE AND TIME Next working day

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:

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

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

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc