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
You may also try this formula.
=DATEDIF(B2,TODAY(),"y")&" years, "
&DATEDIF(B2,TODAY(),"ym")&" months, "
&(DATEDIF(B2,TODAY(),"D"))-(DATEDIF(B2,EDATE(B2,DATEDIF(B2,TODAY(),"M")),"D"))&" days"
=DATEDIF(C8,TODAY(),"y")&" years, "
&DATEDIF(C8,TODAY(),"ym")&" months, "
&DATEDIF(C8,TODAY(),"md")&" days"If the cell is empty what would I add to the formula to not calculate?
Thank you for all your great information.
You can use below :
=IF(C8="","",DATEDIF(C8,TODAY(),"y")&" years, "&DATEDIF(C8,TODAY(),"ym")&" months, "&DATEDIF(C8,TODAY(),"md")&" days")
Thanks
Tauqeer
