Forum Discussion
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, ...
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
In your formula for days part
&today()-DATE(YEAR(today()),MONTH(today()),1)you actually subtract from from TODAY() first day of the current month. If today is 31st it always gives 31-1=30.
I'd use
=DATEDIF(B2,C2,"y") & " years " & DATEDIF(B2,C2,"ym") & " months " & DATEDIF(B2,C2,"md") & " days"