Forum Discussion

RuiPe1050's avatar
RuiPe1050
Copper Contributor
Nov 10, 2020
Solved

Unexpected error while trying to use DATEDIF

Hi,

 

I am trying to use the DATEDIF function but I get an unexpected error. I've read many online examples and I'm doing everything correctly.

I type "=DATEDIF(", click on the cell with the first date (thus now appearing "=DATEDIF(H6") press "," (now appearing "=DATEDIF(H6,") but when I click the second cell to insert the final date, the error seen in the attached picture appears!

Even if I copy/paste those online examples this error always pops up.

 

I'm using Microsoft Office Professional Plus 2016.

 

What's happening?

 

Thanks!

excel
Formulas and Functions

6 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Nov 10, 2020

    RuiPe1050 

    Do you use comma as decimal separator? If so, you should use semi-colon ; to separate the arguments of a function. For example:

     

    =DATEDIF(H6;J6;"m")

    • RuiPe1050's avatar
      RuiPe1050
      Copper Contributor
      Nov 10, 2020

      HansVogelaarNo, I use "." for decimal separator but the ";" worked...

       

      Every examples I've seen, including Excel 2016 Help use "," with this function.

       

      Rui

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Nov 10, 2020

        RuiPe1050 

        Perhaps you have specified ; as list separator in the Region control panel in Windows, or else in Excel in File > Options > Advanced > Editing Options

Resources