The EDATE function is one of the most widely used functions for date calculation. It has multiple uses if it is used with other functions of Excel. In this article, we will show the use of EDATE formula for days with 3 ideal examples.
Download Practice Workbook
You can download the practice workbook from here.
Introduction to EDATE Function
- Function Objective:
The EDATE function adds months to a date and returns the date after addition.
- Syntax:
=EDATE(start_date,months)
- Arguments Explanation:
ARGUMENT | REQUIRED/OPTIONAL | EXPLANATION |
start_date | Required | It denotes the starting date for the calculation. |
months | Required | It indicates the number of months to add with the starting date. |
- Return Parameter:
The function returns the date after adding months to the starting date.
- Version:
This function is available for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021 and Excel 365.
3 Ideal Examples of EDATE Formula for Days
It’s time to use the EDATE function. We will show the uses in the following section with 3 different examples. In all cases, the EDATE function will bring out a date after adding specific months to a starting date.
1. Return Date After Specific Months Using EDATE Formula
In this example, we will show the basic use of the EDATE function. In our dataset, we included Date, Months to Add and Result Date columns.
Let’s walk through the procedures for this example.
- Firstly, write the following formula in Cell D5 which will add the month value from Cell C5 with the date from Cell B5.
=EDATE(B5,C5)
- Then, use the Fill Handle to copy the formula in the following cells.
- Finally, we will see months values from Months to Add column are added to the dates from Date column and the result is displayed in Result Date column.
Read More: How to Use Database Functions in Excel (With Examples)
2. Insert TODAY Function in EDATE Formula to Get Date After Certain Days
Now, we will demonstrate the use of the TODAY function with the EDATE function. The TODAY function gives the current date and with that, the EDATE function will add specific months. We are describing the stepwise procedures below for this example.
- Primarily, write the following formula in Cell D5.
=EDATE(TODAY(),C5)
- Then, press Enter.
- Further, use the AutoFill feature of Excel to copy the formula in the following cells.
- Finally, we will see different month values added to our current date.
Read More: Can Excel DGET Return Multiple Records [See 4 Solutions]
3. Apply COUNTIFS Function with EDATE Function to Count Tasks in Specific Periods of Days
In this example, we will apply the COUNTIFS function with the EDATE function. For that, we have included some Issue, Starting Date, End Date and Count columns. In the Count column, we will count the number of Starting Date between End Date and next month of End Date. Follow the stepwise procedures given below.
- Firstly, apply the following formula in Cell E5.
=COUNTIFS(($C$5:$C$9),">="&D5,($C$5:$C$9),"<"&EDATE(D5,1))
- Then, hit Enter.
In this formula, the COUNTIFS function counts the number of dates from the range $C$5:$C$9 that satisfies the condition “>=”&D5 and “<“&EDATE(D5,1). And the EDATE function finds the date after 1 month from the date of Cell D5.
- Afterward, use the Fill Handle to copy the formula in the cells below.
- Finally, we will see the number of Starting Date between End Date and the next month after End Date in Count column.
Read More: How to Use DCOUNT Function in Excel (5 Suitable Examples)
How to Add Days to a Date in Excel
Addition of days to a date is quite simple in Excel. Excel stores the date values as plain numbers starting from 1 January 1900. We will simply add plain number of days to dates to get the next dates. Follow the stepwise procedures given below.
- Firstly, just write the following formula in Cell D5.
=B5+C5
- Then, press Enter.
- Afterward, use the AutoFill feature to copy the formula in the following cells.
- Finally, we will see the number of days from Days to Add column added to the dates from Date column and the results are displayed in Result Date column.
Things to Remember
- The #NUM! error will occur if the date from the calculation is an invalid one.
- Don’t forget to format the cells for dates from the Number Format option in the Excel ribbon.
- If we insert fractional months as the arguments of the EDATE It will discard the fractional value and add the integer part only to the starting date.
Conclusion
Hopefully, you will be able to use the EDATE function in various ways following this article. If you have any queries or suggestions, let us know in the comment section. Visit our ExcelDemy Website for similar articles regarding Excel.