Forum Discussion
calculer le nombre de mois entre deux dates
Bonjour je suis sur office 365. La fonction =DATEDIF ne semble pas fonctionner !
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
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