Excel EDATE() Function

Excel EDATE() Function

The EDATE() function in excel returns the serial number of the date that is the indicated number of months before or after the start date.

Syntax

EDATE(Start_Date, Month)

Parameter

Start_Date(required)- This parameter represents the date from which you calculate the before and after the date.

Month(required)- This parameter represents the month in numeric format.

Category

Date & Time

Return

This function returns the serial number of a particular date.

Example 1

Objective: To calculate the 3 months after the date indicated in the value cell.

Value	Result	Formula
11/12/2017	2/12/2018	=EDATE(A22,3)
10/22/2018	1/22/2019	=EDATE(A23,3)
7/24/2018	10/24/2018	=EDATE(A24,3)
10/22/2019	1/22/2020	=EDATE(A25,3)

Example 2

Objective: Get the date of 3 months ago from the date indicated in the value cell

Value	Result	Formula
11/12/2017	8/12/2017	=EDATE(A22,-3)
10/22/2018	7/22/2018	=EDATE(A23,-3)
7/24/2018	4/24/2018	=EDATE(A24,-3)
10/22/2019	7/22/2019	=EDATE(A25,-3)

Related Topics

Multiplication in Excel

Multiplication plays a vital role in Mathematics. Usually, the calculations are performed manually and automatically. Manual calculations take time and sometimes leads to error, and it is a challenging process...

5 minutes read.

Notes in Excel

Notes in Excel Notes are used to include additional information to the cell and explain formulas calculation, any modification made to the cell, providing necessary information on data that is entered or to provide any...

3 minutes read.

Excel WORKDAY() Function

Excel WORKDAY() Function The WORKDAY() function in excel returns the serial number of the date before or after a specified number of workdays. Syntax WORKDAY (START_DAY, DAYS, [HOLIDAYS]) Parameter START_DAY (required)- This parameter represents the...

1 minute read.

Reverse List in Excel

What is Reverse list in Excel? Microsoft Excel is widely used for calculation purposes like statistical and analytical for predicting and getting the result. Sometimes for calculation purposes, the user needs...

5 minutes read.

Date and Time in Excel-VBA

In this modern world of computer technology the creation of Excel reports are termed to be the crucial elements, and the particular type of programs that helps us in performing...

6 minutes read.

How to generate random numbers in Excel

In this tutorial, we will discuss the following things in detail that are as follows: Introduction about Random Numbers used in Microsoft Excel. Discuss how to generate the Random Numbers in Microsoft...

6 minutes read.

Excel IFNA Function

Excel IFNA Function The IFNA in Excel is used to remove the #N/A type of errors in excel values cells with our choice of value. IFNA function is from Excel 2013 onwards, so it...

1 minute read.

Excel MIN() Function

Excel MIN() Function The MIN() function in excel returns the smallest or minimum value from the provided numbers, named range or array. It ignores logical values and text. Syntax MIN(Number1,Number2, ...) Parameter Number1(required)- This parameter represents the...

1 minute read.

Excel AVERAGE() Function

Excel AVERAGE() Function The AVERAGE() function returns the average of its arguments, which can be number or names, arrays, or references that contain numbers. It ignores text values and blank cells. Syntax AVERAGE(Number1,Number2, ...) Parameter Number1(required)- This parameter...

1 minute read.

Locate Maximum Values in Excel

Excel is a combination of numeric values and numbers. To retrieve the result, Excel provides various formulas and functions. Sometimes the user needs to find the largest value from the...

5 minutes read.

Excel OR() Function

The OR() function in excel tests the multiple sets of conditions and returns TRUE if any of the arguments are TRUE and FALSE if all the arguments supplied do not meet the...

2 minutes read.

Excel HOUR() Function

Excel HOUR() Function The HOUR() function in excel converts a serial number to an hour (0 - 23). Syntax HOUR(SERIAL_NUMBER) Parameter SERIAL_NUMBER (required)- This parameter represents the date or time from which you want to extract...

1 minute read.

Excel Nested IF’s Function

Excel Nested IF’s Function This function in excel helps in checking multiple conditions together by using IF conditions within the IF condition. Syntax if(Logical_Test, [value_if_true], if(Logical_Test, [value_if_true] , [value_if_false])) Parameter Logical_Test (required)- This parameter represents the condition which...

2 minutes read.

Check Marks in Excel

What is a Check Mark? Among various characters checkmark is one of the characters used to indicate that the item or product in the list is correct, chosen or selected. A...

5 minutes read.

Excel File using Password

How to Protect an Excel File using Password? Nowadays Microsoft Excel is widely used by large organizations to small organizations for their personal and professional usage. They share files to various...

2 minutes read.

Gauge Chart in Excel

A Gauge Chart in Microsoft Excel is considered the meter type chart of a group dial chart, which is eventually similar to the speedometer that has the pointer towards the...

7 minutes read.

Unique Values in Excel

The Unique function in Excel filters the list of unique values from the given data like range or array. The data presented is either number, text, date, time etc. This...

3 minutes read.

How to make use of the Wildcard in Excel

In this modern world, it is known that the wildcard characters in Microsoft Excel are considered to be the most essential and unrated features of Microsoft Excel. Besides all these,...

8 minutes read.

Excel MINUTE() Function

Excel MINUTE() Function The MINUTE() function in excel converts a serial number to minute (0 - 59). Syntax MINUTE (SERIAL_NUMBER) Parameter SERIAL_NUMBER (required)- This parameter represents the date or time from which you want to extract...

1 minute read.

Charts in Excel

Charts Definition of Charts A chart is used to show numbers or data in a spreadsheet visually. It is the visual representation of your data. It is a tool that can be used in...

3 minutes read.