EDATE
Formulas / EDATECalculate a date which is a specified number of months before or after a given date.
EDATE(start_date, months)
- start_date - a valid Sourcetable date (REQUIRED)
- months - the number of months to move in the future or past (REQUIRED)
Examples
=EDATE(A1,1)The EDATE function can be used to adjust a given date by a certain number of months. In this example, the EDATE function is used to add one month to a given date.This will return the date in A1 plus one month, which in this case would be March 1, 2018.
=EDATE(A1,3)The EDATE function can also be used to add multiple months to a given date. Here is an example of adding three months to the date in cell A1. This will return the date in A1 plus three months, which in this case would be May 1, 2018.
Summary
The EDATE function is used to calculate dates that are a certain number of months before or after a given date. It is often used to determine maturity dates or due dates that share the same date of the month as the date of issue.
- The EDATE function returns a date on the same day of the month as a given number, n months in the past or future.
- It can be used to calculate expiration dates, maturity dates, and other due dates. Use a positive value to get a date in the future, and a negative value for dates in the past.
- The EDATE function takes two arguments, the first of which is the date and the second of which is the time.
- It requires a valid Sourcetable date start_date.
Frequently Asked Questions
What is the EDATE function?
The EDATE function is a function in Sourcetable which returns a serial number representing a date. It takes two parameters: the start_date and the number of months.
How does the EDATE function work?
The EDATE function truncates positive months and adds them to the start_date. For example, if the start_date is 1/15/2019 and the number of months is 3, the EDATE function will return 4/15/2019.
What are some common uses of the EDATE function?
- Calculating due dates
- Calculating the date of the last day of the month
- Calculating expiration dates
