Forum Discussion
Datedif function
Hi/Bonjour, Is there another function to use to calculate the différence between two dates than DATEDIF ? I tried many times, but theres always an error in the function. I read a lot explanati...
I'm not actually familiar with this function but see link below - seems that where you have "A" in your formula this is not a valid unit code (i.e. for number of days it should be "d", years should be "y", etc.). Also, if this still does not work, try using semi-colon as separator - i.e. =DATEDIF(A1;B1;"d")
https://support.office.com/en-gb/article/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c
https://support.office.com/en-gb/article/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c