Forum Discussion

Pascal FOUREZ's avatar
Pascal FOUREZ
Copper Contributor
Mar 23, 2020

calculer le nombre de mois entre deux dates

Bonjour

 

je suis sur office 365. La fonction =DATEDIF ne semble pas fonctionner !

 

Excel Desktop
General Comment

3 Replies

  • Pascal FOUREZ's avatar
    Pascal FOUREZ
    Copper Contributor
    Mar 23, 2020

    Ok, la syntaxe sur l'aide en ligne est incorrecte. 

    Syntaxe

    DATEDIF(date_début,date_fin,unité)

     

    Il faut mettre des ; entre les éléments et non des ,

  • Abiola1's avatar
    Abiola1
    MVP
    Mar 23, 2020
    Hello,

    The DATEDIF is an unlisted function in Excel including Office 365

    Assuming you have 23/12/2018 in cell A1 and 23/12/2019 in cell B1.

    Your formula will be =DATEDIF(A1,B1,"Y")

    The formula will return the difference which is Year and that will return 1

    =DATEDIF(A1,B1,"m") will return the difference in months
    =DATEDIF(A1,B1,"d") will return the difference in days

Resources