w3resource

Excel EDATE() function

EDATE() function

This function is used to return the serial number that represents the date that is the indicated number of months before or after a specified date.

Version: Excel 2013

Syntax:

EDATE(start_date, months)

Parameters:

Name Description Data Type Required/
Optional
Start_date A date that represents the start date. Dates should be entered by using the DATE function, or as results of other formulas or functions. Date Required
Months The number of months before or after start_date. A positive value for months yields a future date; a negative value yields a past date. Date Required

Remarks:

  • Microsoft Excel stores date as sequential serial numbers so they can be used in calculations. By default, January 1, 1900, is serial number 1, and January 1, 2010, is serial number 40179 because it is 40178 days after January 1, 1900.
  • when start_date is not a valid date, EDATE returns the #VALUE! error value.
  • when months is not an integer, it is truncated.

Example - 1:

The example below finds the date, one month after the date as shown in A2.

edate1

Example - 2:

The example below finds the date, one month before the date as shown in A2.

edate2

Example - 3:

The example below finds the date, two months after the date as shown in A2.

edate3

Previous: Excel DAYS() function
Next: Excel EOMONTH() function



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://www.w3resource.com/excel/excel-edate-function.php