Forum Discussion

Copper Contributor

May 25, 2021

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...

excel

Formulas and Functions

SergeiBaklan
May 25, 2021
groncaglia

You ned to change order of parameters, Start is to be first

Please check attached file
datedif (2) (1).xlsx11 KB

HansVogelaar

MVP

May 25, 2021

groncaglia

Try DATA.DIFF. For example:

=DATA.DIFF(A1; B1; "m")

groncaglia

Copper Contributor

May 25, 2021

Thanks for replying me. I have already tried data.diff but it does not work. I visualize #NAME or #VALUE

SergeiBaklan
Diamond Contributor
May 25, 2021
groncaglia

Please open attached file, in C1 it will be function in your locale.
datedif (2).xlsx9 KB
- groncaglia
  Copper Contributor
  May 25, 2021
  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
  - SergeiBaklan
    Diamond Contributor
    May 25, 2021
    groncaglia
    
    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.