Forum Discussion

Copper Contributor

Jul 31, 2019

Solved

Understanding Datedif regarding days

Look at column C. The days are all 30 days. Why are they all the same? I agree with year and month but I can not figure out days. Another example is Today is July 31, 2019 substract from May 4, ...

excel

Formulas and Functions

nabilmourad
Jul 31, 2019
frontdesksm

Hi
I created a video tutorial about the DateDiff Function in Excel
You can watch it here
https://www.youtube.com/watch?v=9c3DgoTzTU8

Hope that Helps
Nabil Mourad

SergeiBaklan

Diamond Contributor

Jul 31, 2019

frontdesksm

By the way, if to add some cosmetic

=IF(DATEDIF(B2,C2,"y"),DATEDIF(B2,C2,"y") & " years ", "") &
 IF(DATEDIF(B2,C2,"y")+DATEDIF(B2,C2,"ym"),DATEDIF(B2,C2,"ym") & " months ","") &
 DATEDIF(B2,C2,"md") & " days"