Monday, 11 July 2011

Age Calculator!!

Copy paste this formula in Excel and put the date as the column required!!
=DATEDIF($A$1,$B$1,"y")&" yrs "&DATEDIF($A$1,$B$1,"ym")&" months "&DATEDIF($A$1,$B$1,"md")&" days"
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)