Forum Discussion

Elip0304's avatar
Elip0304
Copper Contributor
Jun 01, 2020

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 explanation and tried to copy the formula and the data in the right cell, but it still not working. 

 

Y a-t-il une autre fonction à utiliser pour calculer la différence entre deux dates que DATEDIF?

J'ai essayé plusieurs fois, mais il y a toujours une erreur dans la fonction. J'ai lu beaucoup d'explications et j'ai essayé de copier la formule et les données dans la bonne cellule, mais ça ne fonctionnait toujours pas.

 

Thank you/Merci, 

Élisabeth 

excel
Formulas and Functions

3 Replies

  • Abiola1's avatar
    Abiola1
    MVP
    Jun 02, 2020
    Assuming you have 23/06/2020 in cell A1 and 28/06/2020 in cell B1.

    In cell C1, you have write the simple formula =B1-A1 which will deliver 5 as the result
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Jun 01, 2020

    Elip0304 

    The attached has some DATEDIF formulas that work with English localisation despite my using a mix of date-values and dates as text. If it translates OK to French localisation then you should be able to tell us the correct format.

  • Charla74's avatar
    Charla74
    Iron Contributor
    Jun 01, 2020
    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

Resources