=DATEDIF(D6,TODAY(),"Y")&" Years "&DATEDIF(D6,TODAY(),"ym")&" Months "&1+DATEDIF(D6,TODAY(),"md")&" Days "
D6 - Cell which contains Date
TODAY() - Today's date (Function)
DATEDIF - Function to find date difference
Y - Variable which denote Year difference
ym - Variable which denotes balance month difference after the year
md - Variable which denotes day balance difference after month
*PS : You can change TODAY()with another date cell.
RESULT
No comments:
Post a Comment