Sunday 17 September 2017

How to find differences between two dates on Microsoft office excel.?


FORMULA 

=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