Excel Formulas to Get the Next Day of Week ~ Simple Tricks!!
Tags: excelformula, excelformulas
Published: 2021-05-19 11:40:59

---
title: Excel Formulas to Get the Next Day of Week ~ Simple Tricks!!
published: true
date: 2021-05-18 15:24:43 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-get-the-next-day-of-week/
---

We can use a formula that is based on the **[WEEKDAY function](https://geekexcel.com/how-to-use-weekday-function-in-microsoft-excel-365/)** to get the next day of the week. All you will need is the start date, and then you will be able to effortlessly get the next day of the week. This article provides a clear guide on how we can **get the next day of the week** using a formula based on the WEEKDAY function in Excel. Let’s jump 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)

[![Get next day of week](https://geekexcel.com/wp-content/uploads/2021/05/Get-next-day-of-week.png)](https://geekexcel.com/excel-formulas-to-get-the-next-day-of-week/get-next-day-of-week/#main)<figcaption id="caption-attachment-43822">Get next day of week</figcaption>

## General Formula:

- Use the below formula to find the next day of a week in Excel.

**=date+7-[WEEKDAY](https://geekexcel.com/how-to-use-weekday-function-in-microsoft-excel-365/)(date+7-dow)**

## Syntax Explanations:

- **WEEKDAY** – The **[WEEKDAY Function](https://geekexcel.com/how-to-use-weekday-function-in-microsoft-excel-365/)** in Excel returns a number (ranging from 1 to 7) that represents the day of the week for a given date.
- **Date** – It specifies the input range from your worksheet.
- **Plus operator (+)** – This symbol is used to add the values.
- **Minus Operator (-)** – This symbol will help to subtract any two values.
- **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.

## Example:

Let’s consider the below example image.

- First, we will enter the input dates in **Column B**.
- Here, we need to find out the next Wednesday of the week.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/05/Input-Range-22.png)<figcaption id="caption-attachment-43819">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-60.png)<figcaption id="caption-attachment-43821">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-56.png)<figcaption id="caption-attachment-43820">Result</figcaption>

## Wrap-Up:

From this chapter, you can get some clarification on how to **find out the next day of the week in Excel**. Hope you like it. Please write us below if something is unclear or if you need further assistance on this subject.

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 Also:

- **[Excel Formulas to Calculate the Number of Months Between Two Dates!!](https://geekexcel.com/excel-formulas-to-calculate-the-number-of-months-between-two-dates/)**
- **[Excel Formulas to Calculate How Many Days Open? Easy Method!!](https://geekexcel.com/excel-formulas-to-calculate-how-many-days-open-easy-method/)**
- **[Enter the Date in Excel Sheet ~ Step-by-Step Procedure!!](https://geekexcel.com/enter-the-date-excel/)**
- **[Enter the Date in Excel Sheet ~ Step-by-Step Procedure!!](https://geekexcel.com/enter-the-date-excel/)**