Excel Formulas to Check Date is Same Month ~ A Complete Tutorial!!
Tags: excelformula, excelformulas
Published: 2021-05-11 05:38:56

---
title: Excel Formulas to Check Date is Same Month ~ A Complete Tutorial!!
published: true
date: 2021-05-10 11:34:35 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-check-date-is-same-month/
---

If you have two lists of dates, now, you need to compare the dates and display the result as True when the dates belong to the same month. Otherwise, the result should be False. How could you **check whether the date is the same month or not 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)

[![Check the date is same month](https://geekexcel.com/wp-content/uploads/2021/05/Check-the-date-is-same-month.png)](https://geekexcel.com/excel-formulas-to-check-date-is-same-month/check-the-date-is-same-month/#main)<figcaption id="caption-attachment-39141">Check the date is the same month</figcaption>

## General Formula:

- You can use the below formula to check if the dates have the same month and year.

**=[MONTH](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)(date1)=MONTH(date2)**

## Syntax Explanations:

- **MONTH** – This function helps to extract the month number ranging from 1 (JAN) to 12 (DEC) from the given date and displays the output. Read more on the [**MONTH function**](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/).
- **Date** – It represents the input range 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.

## Example:

Let’s consider the below example image.

- Here, we will enter the input dates in **Column B** and **Column C**.
- Now we are going to compare these two dates and check the dates are the same month.

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

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

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-30.png)<figcaption id="caption-attachment-39142">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/Result1.png)<figcaption id="caption-attachment-39140">Result</figcaption>

## Closing Words:

From this tutorial, you can get some clarification on how to **check the date is the same month or not in Excel**. Hope you like this article. If you have any **doubt** regarding this article or have any other **questions** related to Excel, let me know in the **comments** section below.

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/) **!! **

### Related Articles:

- **[Excel Formulas to Count Times in a Specific Range ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-count-times-in-a-specific-range/)**
- **[How to Increment a Value by Row or Column in Excel Office 365?](https://geekexcel.com/how-to-increment-a-value-by-row-or-column-in-excel-office-365/)**