How to use Edate in Excel

Source: Internet
Author: User

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.