Forum Discussion

ivanakustura08's avatar
ivanakustura08
Copper Contributor
Aug 01, 2024

excel datadif

please help me, I'm trying to use the datadif formula, but it keeps giving me an error, i.e. that the formula is not correct, please help me, how to solve this problem

  • ivanakustura08 

    In the English language version of Excel, the syntax is

     

    =DATEDIF(start_date, end_date, unit)

     

    where unit can be "d", "m", "y", "md", "ym" and "yd". The results with "md" are not entirely reliable.

    If you use comma as decimal separator, use semicolon between the arguments:

     

    =DATEDIF(start_date; end_date; unit)

     

    In other languages, the function may have a different name.

Resources