[Fixed!] EDATE Function Not Working in Excel

Businesses use Excel functions like EDATE for a variety of tasks, including tracking data records, scheduling, and producing analytical reports. If using Excel is part of your job, you should be aware of how to correct frequent issues so you can operate the program efficiently. For instance, errors in the Excel document frequently occur, and whenever an EDATE function issue arises, Excel shows an error message that starts with the hash (#) symbol. Therefore, this article will show you 6 reasons with solutions to fix the issues when EDATE function not working in Excel.

Download Practice Workbook

Download this practice workbook to exercise while reading this article. It contains all the datasets in different spreadsheets for a clear understanding. Try it yourself while you go through the step-by-step process.

6 Reasons with Solutions to Fix Issues When EDATE Function Not Working in Excel

Excel notifies us if there’s a problem with the EDATE function we are using or the data we are referring to when we use formulas to conduct computations. The application can generate several error messages. However, while repairing the faults may initially seem difficult, it is quick and simple once we comprehend them. With that in mind, in this article, we will show you how to fix these issues quickly and effectively. For demonstration, we take a dataset that represents a schedule book with the application of the EDATE function. As we can see in column D, Excel is displaying some errors.

excel edate function not working

Reason 1: #NAME! Error

The #NAME! error typically results from a non-existence function. This error pops up in our spreadsheet when Excel can’t read some of our calculations. Moreover, this can happen if we spell some formula components incorrectly or if some components are missing.

#NAME! Error When EDATE Function Not Working in Excel

Solution: Correct Formula Spelling

The simplest way to solve this issue is to meticulously review our formula and check that all of its components are spelled correctly. As an alternative, we can highlight the cells we use for the EDATE  formula, then choose the function bar (fx) from the top-bar menu. To ensure accurate data entry, we correct the function spelling to have the right output.


  • Firstly, in cell D5, type


  • Afterward, press Enter key.

Correct Formula Spelling

  • Later, use the AutoFill icon to drag the formula cell down.
  • Thus, we fix the function error.

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

Reason 2: #VALUE! Error

When our formula refers to letters, text, or spaces rather than the number it should be addressing, Excel displays #VALUE! error. Moreover, if the inputs are in Text formats this error pops up. See the picture below for a better understanding.

#VALUE! Error when excel edate function not working

Solution: Use Format Cells Option to Convert Text Values to Date

The date serial number that EDATE returns, has to be as a date. Also, we check our formula to make sure to refer to the right cell to resolve this issue. If our calculation is accurate, then the cell itself probably contains some incorrect characters. Excel distinguishes between text and numerical values, therefore changing a cell’s format to include numbers rather than text can also fix this issue.


  • First, select the range C5:C9 and right-click on it.
  • Subsequently, a context menu appears.
  • There, select the Format Cells option.

Use Format Cells Option to Convert Text Values to Date

  • Consequently, the Format Cells dialog box slides into the display.
  • Now, click Number → Date → March 14, 2012 → OK.

  • Hence, we format the Text values to Date format.

  • After that, we type the following formula in cell D5,


  • By pressing Enter, we display the output.

  • Lastly, use the AutoFill tool to display the rest.

Read More: How to Use Database Functions in Excel (With Examples)

Reason 3: #NUM! Error

When the start date is incorrect, the EDATE function returns the error #NUM! Because the method only accepts dates between 1/1/1900 and 12/31/9999, the formula below in D5 is invalid.

=EDATE(C5, 100^3)

  • The function returns a date that is out of the above-mentioned range. As a result, Excel returns a #NUM! error.

#NUM! Error when excel edate function not working

Solution: Input Valid Numeric Data

To fix this issue, we can input numeric data that lies in between Excel’s programmed date range.


  • In cell D5, type:


  • After that, tap the Enter key.

Input Valid Numeric Data

  • Next, drag the AutoFill tool down.
  • Thus, the errors disappear.

Read More: How to Use DCOUNT Function in Excel (5 Suitable Examples)

Similar Readings

Reason 4: #REF! Error

Our formula encounters the #REF! error when it tries to refer to a deleted cell. The cells we are referring to may be inaccurate even though the formula is correct.

#REF! Error when excel edate function not working

Solution: Use Keyboard Shortcuts to Recover Deleted Cells

To correct this issue, simply use the “Undo” command or a keyboard shortcut. These actions reverse the cell’s deletion, enabling our formula to successfully reference it once more. Additionally, we can check the cell the formula refers to make sure data is being displayed.


  • To begin with, press the  Ctrl + Z  keys.
  • Eventually, the missing column appears in our dataset.

Use Keyboard Shortcuts to Recover Deleted Cells

  • Later, type the formula below.


  • Also, use the AutoFill icon to fill the rest of the column.

Read More: How to Determine If a Number Is Even in Excel (4 Suitable Ways)

Reason 5: #NULL! Error

The #NULL! errors frequently show up when our formula contains an incorrect space. The problem is typically caused by placing a space where a comma or colon should be. A space represents the Range Intersect operator, while a comma combines two references. Alternatively, a colon refers to a range of cells.

#NULL! Error when excel edate function not working

Solution: Add Missing Colons or Commas

Let’s make sure our formula doesn’t contain any unintentional spaces to solve this issue. Also, we have to keep in mind that the cells we are addressing are in accurate space if we are trying to use space to call upon two intersecting cells.


  • Similarly, in D5, write


  • Later, press Enter.

Add Missing Colons or Commas

  • Finally, hold and drag the AutoFill icon down.
  • Thus, we fix the errors perfectly.

Reason 6: ###### Error

One of the most frequent problems in Excel is the #### error, and it’s simple to repair. When a column’s width is insufficient to display all the characters in a cell, Excel prints this error message. When Excel displays a negative time and date, this mistake might also happen.

###### Error when excel edate function not working

Solution: Expand Column Width

We may easily remedy the occurrence of this problem by enlarging the column width to fit all the characters in a cell. The column’s header can be moved until we fix the problem. If the problem persists, we can also alter the size of each cell separately. Follow the steps to do so.


  • Drag the right edge of column D.
  • Thus, the errors disappear.

Enhance Column Width

Read More: Can Excel DGET Return Multiple Records [See 4 Solutions]


In this article, we have thoroughly discussed 6 reasons with solutions to fix issues when EDATE function not working in Excel. Not to mention, our ExcelDemy website shows various simple problem-solving methods like this. Please leave any further queries or recommendations in the comment box below.

Related Articles

Yousuf Khan

Yousuf Khan

Hello! This is MD Yousuf Khan. I am a graduate & post-graduate in Information Technology from Jahangirnagar University, Bangladesh. Currently, I am writing articles for ExcelDemy. I am an independent, self-motivated person with enthusiasm to learn new things, and always try to do my best in any work assigned to me.

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