In this article, you will learn how to utilize the EDATE formula in Google Sheets. The EDATE formula is beneficial when you need to know a date that is a specific number of months before or after a particular date.
The general formula is as follows:
Start_date: A date from which the formula computes another date based on the input in “months” defined in the following argument.
Months: The number of months that is added (if positive) or subtracted (if negative) to the “start_date”. You can input a positive or negative number or zero in this argument.
This formula is helpful when you want to compute a date particular number of months before or after another date. (e.g., five months after today or eleven months before 10/3/2022). Look at the examples in the following screenshots.
This formula shows the date five months after 10/4/2022.
This formula shows the date nine months before 10/4/2022.
The DATE function is helpful for inputting a date correctly. Check this article to learn how to use it.
This formula shows the date nine months before TODAY()*.
*The date when this article was written is 10/4/2022.
This example presents that a formula is used to fill “start_date” in the first argument.
Start_date: EOMONTH(“10/4/2022”,0) (Note: the formula left returns 10/31/2022)
This formula shows the date three months before 10/31/2022.
This example shows the EDATE formula containing another date-related function. The EOMONTH function helps you know the end date of a specific month. Check this article to learn how to use it.
This formula shows the date nineteen months after 10/3/2022.
This example shows a case of the EDATE formula incorporating cell reference for its input.
This formula shows the date four months after 10/4/2022.
This example shows another case of the EDATE formula incorporating cell reference for its input.
If you don’t get the right answer to your question in this article or you have other questions related to date and/or time, you may find the answers in the following articles.
Formulas related to dates
EOMONTH Function in Google Sheets: Explained - understand an end date of a month
DATEVALUE Function in Google Sheets: Explained - convert a date into a serial number
Formulas related to time
How to Insert Current Time in Google Sheets - NOW function
Are you learning this formula to build a financial KPI dashboard or conduct financial analysis? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access other templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.
To learn more about LiveFlow, book a demo.
Learn how to do this step-by-step in the video below 👇