DateDif fonction

Copper Contributor

Clementje_1-1653325124828.png

 


Hi every one,
I am trying to calculate the age of a lap top from the date of purchase using the formula DateDif has show above.
I keep getting an error, so I double check many things, like the date format in C3 (which is correct), I use the format  today() , but I keep getting the error :

Clementje_2-1653325455200.png

 

Any one can help ?

 

Thanks,

 

Clement

 

2 Replies

@Clementje 

=DATEDIF(C3,TODAY(),"m")

It works in my sheet when i enter C3 without " ".

datedif.JPG

Hi @OliverScheurich ,
Thanks for looking into it, I tried without "" also with , and ; but I was keeping on getting the error.
When I changed the date system to 1904 in the advance option, then it works :) 

Clementje_0-1653425022615.png