Forum Discussion
ivanakustura08
Aug 01, 2024Copper Contributor
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
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.