Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts

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