Excel Formulas to Find the Next Working Day ~ Quick Solution!!

Suppose you are given a date, and you are asked to calculate the next working day if the date is of the weekend. If the date is a regular workday, then you should show the same date. Here, we will show the simple formula to find the next working day in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

Use the below formula to find the next working day in Excel.

=WORKDAY(date,1,holidays)

Syntax Explanations:

WORKDAY – In Excel, the WORKDAY function helps to calculate the proximate working day based on the value we provide and returns a number that represents the date.
*Date * – It specifies the input dates from your worksheet.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

Here, we will enter the input values in Column B.
Now we are going to calculate the next working day.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Wind-Up:

Hope you like this article on how to find the next working day in Excel. If you have any questions or suggestions regarding this lesson, feel free to use the comments section below to let us know.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **