Excel Formulas to Find the Same Date in a Next Month!!
Tags: excelformula, excelformulas
Published: 2021-05-21 02:39:45

---
title: Excel Formulas to Find the Same Date in a Next Month!!
published: true
date: 2021-05-20 07:57:27 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-the-same-date-in-a-next-month/
---

One of the most commonly used formats in Microsoft Excel is dates. Over time, Excel has added some very cool features regarding dates. One such feature is to get the same date next month. In this guide, we will show the simple formula to **find the same date in the next month in Excel**. Let’s get into the 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)

[!["Find](https://geekexcel.com/wp-content/uploads/2021/05/Find-the-same-date-in-next-month.png)](https://geekexcel.com/excel-formulas-to-find-the-same-date-in-a-next-month/find-the-same-date-in-next-month/#main)

## General Formula:

- You can use the below formula to find out the same date in the next month.

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

## Syntax Explanations:

- **EDATE** – This function helps to add the specified month to the given start date and returns the result date’s serial number. Read more on the [**EDATE Function**](https://geekexcel.com/how-to-use-edate-function-in-excel-365/).
- **Date** – It represents 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.

- First, we will enter the input dates in **Column B**.
- Now we are going to find out the same date in the next month.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/05/Input-Range-26.png)<figcaption id="caption-attachment-44455">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-68.png)<figcaption id="caption-attachment-44457">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-64.png)<figcaption id="caption-attachment-44456">Result</figcaption>

## Conclusion:

From this guide, you can get some clarification on how to find the **same date in the next month**. Let me know if you have any **doubts** regarding this article or any other article on this site.

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 Get the Nth day of the Year ~ A Complete Guide!!](https://geekexcel.com/excel-formulas-to-get-the-nth-day-of-year/)**
- **[Excel Formulas to Find the Most Recent Days of a Certain Week!!](https://geekexcel.com/excel-formulas-to-find-the-most-recent-days-of-a-certain-week/)**
- **[How to Count missing values in a list in Excel Office 365?](https://geekexcel.com/how-to-count-missing-values-in-a-list-in-excel-office-365/)**
- **[Excel Formulas to Extract the Month From Date ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-extract-the-month-from-date/)**