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...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 10, 2020

    RuiPe1050 

    Perhaps you shall use semicolons instead of commas as delimiter =DATEDIF(H6; ...

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 10, 2020

RuiPe1050 

Perhaps you shall use semicolons instead of commas as delimiter =DATEDIF(H6; ...

RuiPe1050's avatar
RuiPe1050
Copper Contributor
Nov 10, 2020

SergeiBaklanThe ";" worked... but all the examples I've seen, including Excel 2016 Help, use "," with this function and I'm not using "," as decimal separator.

 

Thanks!

 

Rui

Resources