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

tauqeeracma

Iron Contributor

Jul 31, 2019

frontdesksm

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"

frontdesksm

Copper Contributor

Aug 02, 2019

=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.

tauqeeracma
Iron Contributor
Aug 02, 2019
frontdesksm

You can use below :

=IF(C8="","",DATEDIF(C8,TODAY(),"y")&" years, "&DATEDIF(C8,TODAY(),"ym")&" months, "&DATEDIF(C8,TODAY(),"md")&" days")

Thanks
Tauqeer
- frontdesksm
  Copper Contributor
  Aug 02, 2019
  Yea again..I am so excited. Thank YOU!!!!
  tauqeeracma
  - tauqeeracma
    Iron Contributor
    Aug 02, 2019
    You are welcome frontdesksm