Excel

EDATE: Excel Formulae Explained

How do you use EDATE in Excel?

The Excel EDATE function returns the serial number of the date that is the indicated number of months before or after the supplied date. The supplied date must be a date in a valid Excel date format, such as "1/1/2015". The date argument can be either positive or negative, and indicates the number of months before or after the supplied date. If the date argument is omitted, Excel uses the current date.

The following example uses the EDATE function to return the serial number for the date six months before the current date.

=EDATE(A2,-6)

This example uses the EDATE function to return the serial number for the date six months after the current date.

=EDATE(A2,6)

What is the syntax of EDATE in Excel?

The syntax of EDATE in Excel is as follows:

=EDATE(date,months)

Where:

date is the date you want to calculate

months is the number of months you want to add or subtract from the date

What is an example of how to use EDATE in Excel?

EDATE is a function in Excel that calculates the expiration date of a security or coupon based on the issue date and the number of days since the issue date. For example, if you have a security that expires on March 1, 2019, and you want to know how many days are left until it expires, you would use the EDATE function like this: =EDATE("3/1/2019",TODAY()-DAY(3/1/2019)) This would return the value of "62" which means that there are 62 days left until the security expires.

When should you not use EDATE in Excel?

There are a few occasions when you should not use the EDATE function in Excel. One example is when you want to calculate the number of days between two dates. The EDATE function always assumes that the date you are using as the basis for the calculation is the first day of the month. This can cause problems if the date you are using is not actually the first day of the month. For example, if you want to calculate the number of days between September 1 and October 31, the EDATE function will return the number of days in September, which is not what you want.

What are some similar formulae to EDATE in Excel?

In Excel, the EDATE function returns the serial number of the date that is the number of days before or after the specified date. The DATE function returns the serial number of a date, while the DAY function returns the day of the month for a date. The MONTH function returns the month of a date, and the YEAR function returns the year for a date.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.