How to Use EDATE Formula for Days (3 Ideal Examples)

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

edate formula for days

  • 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.

Return Date After Specific Months Using EDATE Formula

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.

Insert TODAY Function in EDATE Formula to Get Date After Certain Days

  • 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.

Apply COUNTIFS Function with EDATE Function to Count Tasks in Specific Periods of Days

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.

How to Add Days to a Date in Excel

  • 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.


Related Articles

Mehedi Hasan Shimul

Mehedi Hasan Shimul

Hi! I am Mehedi Hasan Shimul. As I am an Engineer solving different problems with the help of Excel amuses me. I write Excel related different problem solving articles here. Hope it will help you.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo