Excel Formulas to Find the Next Working Day ~ Quick Solution!!
Tags: excelformula, excelformulas
Published: 2021-05-27 03:29:31

---
title: Excel Formulas to Find the Next Working Day ~ Quick Solution!!
published: true
date: 2021-05-26 13:44:47 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-the-next-working-day/
---

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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Next working day](https://geekexcel.com/wp-content/uploads/2021/05/Next-working-day.png)](https://geekexcel.com/excel-formulas-to-find-the-next-working-day/next-working-day/#main)<figcaption id="caption-attachment-45627">Next working day</figcaption>

## Generic Formula:

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

**=[WORKDAY](https://geekexcel.com/how-to-use-workday-function-in-excel-365/)(date,1,holidays)**

## Syntax Explanations:

- **WORKDAY** – In Excel, the [**WORKDAY function**](https://geekexcel.com/how-to-use-workday-function-in-excel-365/) 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.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/05/Input-Range-37.png)<figcaption id="caption-attachment-45630">Input Range</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-87.png)<figcaption id="caption-attachment-45629">Enter the formula</figcaption>

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

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-81.png)<figcaption id="caption-attachment-45628">Result</figcaption>

## 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](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to List Holidays between Two Dates ~ Easy Tips!!](https://geekexcel.com/excel-formulas-to-list-holidays-between-two-dates/)**
- **[Excel Formulas to Find the Next biweekly payday with From Date!!](https://geekexcel.com/excel-formulas-to-find-the-next-biweekly-payday-with-from-date/)**
- **[How to Search for a Value in All Tabs in Excel Office 365?](https://geekexcel.com/how-to-search-for-a-value-in-all-tabs-in-excel-office-365/)**
- **[Excel Shortcut: Enter and Move Right in MS Excel 365!!!](https://geekexcel.com/simple-shortcut-to-enter-and-move-right-in-ms-excel-365/)**