Forum Discussion
Solved
I do not have the function DATE.DIF
Good morning, I have a weird problem with excel. In the laptop that I am using, I have never had the function DATE.DIF. I wonder why I don't have this function on excel. Nevertheless, I need it a...
Thanks for replying me. I have already tried data.diff but it does not work. I visualize #NAME or #VALUE
Please open attached file, in C1 it will be function in your locale.
SergeiBaklan thanks for your answer.
I opened your file, and, it's incredible, this function works only in C1. If I paste the function and I try it in whatever cell it does not work, and I visualize #NUM! . I tried also to insert "d" instead of "m" but it still does not work.
I did the same in other my excel files and, again, it does not work
If you open the file attached it shall be shown in Italian locale. Perhaps you may share file/screenshot of how it looks when returns an error in your file.
SergeiBaklan ok, I've attached the file. Please, notice that I wrote the correct formula
I suspect that DATEDIF is not available in the Italian version of Excel.
- surely, indeed I tried to use the Italian =DATA.DIFF but, because it does not work, I tried also DATEDIF, but there is nothing to do
