Monday, November 11, 2013

Date Difference in Microsoft Excel

Here, Cell A2 = From Date 
and B2 = To Date
Now, Type this Formula in Date Difference Field

= DATEDIF (A2,B2,"Y")&" Years, "&DATEDIF(A2,B2,"YM")&" Months, "&DATEDIF(A2,B2,"MD")&" Days"

Date Difference in Microsoft Excel


No comments:

Post a Comment