Can't use the datedif function

Copper Contributor

Hello,  I'm trying to get average age from date of birth in an Excel sheet (Microsoft 365) and the function to be used is datedif but nothing works, I always get this message.  Help!

Mcharbon_0-1713987006463.png

 

2 Replies

@Mcharbon 

If you use comma as decimal separator, you should use semicolon ; between the arguments of the function. For example:

=DATEDIF(A1; B1; "m")

 

@Hans Vogelaar  many thanks, it now works!