Google Sheets | EDATE | Function | Example | How To | Spreadsheet Tutorial | Quick Review
Use Google Sheets EDATE function to get the date after or before the specified number of months from the specified starting date. It is like EOMONTH function in that the type and number of arguments are the same, which is two.
-------------------------------------
Google Sheets Quiz with Demo of Answers
Try this 5-question quiz, which also demos the answers. The quiz can be helpful in your day-to-day spreadsheet work or for job interview:
• Google Sheets Functions Quiz | Fill-in-the...
-------------------------------------
The EOMONTH function returns the last date of the month before or after the
specified number of months. Here is the link to the step-by-step video tutorial:
• Google Sheets | EOMONTH | Function | Examp...
-------------------------------------
How to Fill a Row or Column with the Consecutive Numbers Easily?
If you wish to fill a row or column with consecutive numbers quickly, this
tip can help you in this task:
• Google Sheets | How To | Fill Cells with N...
-------------------------------------
Why does these Matter for your Health?
Take a look at the nine not-so-common tips for good health:
• Health Tips for Good Health
-------------------------------------
Let's look at the format of the EDATE function formula:
=EDATE(start_date, [months])
Start the formula with an equal-to symbol.
EDATE is the name of the function.
start_date is the reference date. It can be, for example, a hard-coded date or a cell address with a date.
months is optional, and are the number of months after or before the reference date. Like the start_date argument, months can be, for example, a hard-coded number or a cell address.
The months argument can be a positive or negative number. A positive number indicates that the number of months are after the start date. A negative number indicates that the number of months are before the start date.
Here are some examples of the EDATE function formula:
Example 1
=EDATE("07/28/2030", 96)
The above formula returns 7/28/2038 as the date after 96 months from 7/28/2030.
Example 2
=EDATE("02/05/2025", -14)
Note that months is a negative number in the formula.
The formula returns 12/5/23. That is, the result is the date before 14 months, because of negative a value for months, from the start_date.
Example 3
=EDATE(A3,B5)
Assume that cell A3 has the date 10/21/2032 and cell B5 has the number 3.
The formula returns 1/21/2033.
Take a look at this video tutorial, which gives the steps to use the Google Sheets EDATE function, for calculating the date before or after the specified months from the specified start date.
Sur cette page du site, vous pouvez voir la vidéo en ligne Google Sheets | EDATE | Function | Example | How To | Spreadsheet Tutorial | Quick Review durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Software Spring 04 juillet 2022, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 1,226 fois et il a aimé 12 téléspectateurs. Bon visionnage!
