Having excel to calculate from start-date to end-date = number of months My formula do not work??

[Abildgaard2020]

1/2/2006

1/03/2019

I am entering =DATEDIF(start cell, end-cell,"Y")  but excel will not accept the formula ?? 

[#2]

@Abildgaard2020 

Here is a small example with calculating the date.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

* Beware of scammers posting fake support numbers here.

[#3]

@Abildgaard2020 

In general function works.

better if you submit sample file to check what's wrong

[#4]

@Abildgaard2020 

Sometimes depending on the language selection it can happen that the quotes in the formula are not accepted and #NAME or error appears.That happened to me once too.
Then you can quickly copy the formulas and off you go.

=DATEDIF(F1;G1;"Y")

Here in a worksheet with the formula in action