How to Use Excel EDATE Function in Office 365? – Easy Steps
Tags: excelfunctions, edatefunctioninexcel, excel, exceltutorials
Published: 2020-12-15 09:20:01

---
title: How to Use Excel EDATE Function in Office 365? – Easy Steps
published: true
date: 2020-12-12 06:30:35 UTC
tags: ExcelFunctions,EDATEFunctioninExcel,Excel,ExcelTutorials
canonical_url: https://geekexcel.com/how-to-use-edate-function-in-excel-365/
---

## **EDATE Function in Excel:**

Usually, the date will show the time at which an event occurs. Excel uses the EDATE Function to find data that is the indicated number of months before or after a specified date. It is a **Built-in Function** in Excel. The **EDATE Function** adds or subtracts the specified number of months with the given date and returns the serial number that represents the result date in Excel.

Here, we come up with the simple steps to Use **Excel EDATE Function in Office 365**. Get the 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)
## EDATE Function Syntax:

```
**=EDATE(start\_date,month) **
```

- **EDATE** Function adds the specified month to the given start-date and returns the result date’s serial number.
- **DATE Format: ** the Default Date Format in Excel is “ **MM/DD/YY** “.

## EDATE Function with Practical Examples:

Look at the below examples.

### Example 1:

![EDATE Function Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/02/Screenshot_2-15.png)<figcaption id="caption-attachment-4183">EDATE Function Example 1</figcaption>

- Let us assume a date 1 Jan 2019 and if you need to find the **EDATE** after 5 months and then you have to use the formula **=EDATE(“1/1/19”,5) or EDATE(C6,5).** It will print the serial number of the result date **6/1/19.**
- To find the date of the output serial number and then use the formula **=TEXT(cell, format)**
- For Example, **=TEXT(E6,”m/d/y”)** It will display the date format of the serial number.

![EDATE Function Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/02/Screenshot_1-15.png)<figcaption id="caption-attachment-4187">TEXT Function Example</figcaption>

### Example 2:

![EDATE Function Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/02/Screenshot_3-14.png)<figcaption id="caption-attachment-4188">EDATE Function Example 2</figcaption>

- Here is the example to find the **EDATE Function** before **7 months** from the given date **4 July 2019** and then the EDATE function returns the serial number of the result date.

## A Quick Synopsis:

In this article, we have discussed the **EDATE Function** syntax, definition, and usage in Excel Office 365 with practical examples. Please leave your comments in case of any **queries** and share your **suggestions** in the comment box. Thank you for visiting our website **[GeekExcel](https://geekexcel.com/)**.

## Related articles:

- **[DATEVALUE Function in Excel](https://geekexcel.com/how-to-use-datevalue-function-in-excel-365/)**
- **[DAY Function in Excel](https://geekexcel.com/how-to-use-day-function-in-excel-365/)**
- **[DATE Function in Excel](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)**
- **[HOUR Function in Excel](https://geekexcel.com/how-to-use-hour-function-in-microsoft-excel-365/)**
- **[Sum Function in Excel](https://geekexcel.com/sum-function/)**
- **[Month Function in Excel](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)**
- **[ABS Function in Excel](https://geekexcel.com/how-to-use-abs-function-in-microsoft-excel-365/)**
- **[Custom ADD Function](https://geekexcel.com/how-to-create-custom-add-function-in-excel-365/)**