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

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.

Solution examples
I need to create a formula where column D becomes the date in column C + 5 business days when I enter a date into column C
Solved by X. Q. in 14 mins
need help with the different sheets and formula IF(A4=B4,0,NETWORKDAYS(A4+1,B4,\$E\$9:\$E\$42) +0.5*(INT((+B4-A4+1)/7)+IF(WEEKDAY(A4+1)+MOD (B4-A4-1,7)>=7,1,0)))
Solved by O. D. in 11 mins
i have this formula currently which works but not if I want it for every day - any ideas ?? (NETWORKDAYS.INTL(L1362,M1362,11,BH!A:A)-1)*("17:30"-"8:30")+IF(NETWORKDAYS.INTL(M1362,M1362,11,BH!A:A),MEDIAN(MOD(M1362,1),"8:30","17:30"),"17:30")-MEDIAN(NETWORKDAYS.INTL(L1362,L1362,11,BH!A:A)*MOD(L1362,1),"8:30","17:30")
Solved by A. D. in 28 mins