Forum Discussion
Having excel to calculate from start-date to end-date = number of months My formula do not work??
1/2/2006 1/03/2019 I am entering =DATEDIF(start cell, end-cell,"Y") but excel will not accept the formula ??
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