How to use Edate in Excel

First, Edate grammar

EDATE (start_date,months)

Start_date is a date that represents the start date. You should use the DATE function to enter dates, or you can enter the date as the result of another formula or function.

For example, use the function date (2008,5,23) to enter the date May 23, 2008. If you enter the date as text, the problem occurs.

Month is the number of months before or after start_date. A positive number indicates a future date, and a negative number represents the past date.

Ii. Chinese explanations and examples of edate

Look at the above syntax, you do not feel a bit difficult to understand it? The following webmaster use a simple Chinese to introduce to you.

First of all, if your Excel doesn't use the function correctly, do the following:

If the function is not available and returns an error value #NAME?, install and load the Analysis ToolPak add-in.

Let's take a look at the Chinese explanation below.

EDATE (start_date,months), where the start_date parameter is a given date, months refers to the month, that is, from 1 to 12, fill in one.

Of course, months you can also fill in more than 12, more than 12 instructions for more than a year.

The Chinese explanation is as follows:

EDATE (given reference date, month before and after the date)

For example: A1 cell is date type data, the value is: 2012-1-3

So, function =edate (a1,3), which day is the three months after December 3, 2012?

3 is a positive number that represents the date after, and if it is a negative number, represents the previous date. So the result of the function returns to 2012-4-3

If it is =edate (a3,-3), the return result is 2011-10-3

Summary: The function of Edate is to return the date before or after the reference date.