Hi Everyone,
My name is Asmath and i work in IT firm wherein I involve in lot of reporting stuff.
Scenario:
I have two random dates in cell D39 and D40 and I have used DATEIF formula in cell F39 and F40 which calculates the difference between the dates in D39/40 cell with current date in “Years Month Days” format
Now I would like to have a difference between two dates i.e; F39 and F40 cells in the same format as “Years Month Days” in G39 cell
D39 = 5/10/2010
D40 = 8/8/2011
F39 = =DATEDIF(D39,TODAY(),"Y") & " Years, " & DATEDIF(D39,TODAY(),"YM") & " Months, " & DATEDIF(D39,TODAY(),"MD") & " Days"
F40 = =DATEDIF(D40,TODAY(),"Y") & " Years, " & DATEDIF(D40,TODAY(),"YM") & " Months, " & DATEDIF(D40,TODAY(),"MD") & " Days"
Thanks in advance for you help!!
Bookmarks