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"
=DATEDIF($A$1,$B$1,"y")&" yrs "&DATEDIF($A$1,$B$1,"ym")&" months "&DATEDIF($A$1,$B$1,"md")&" days"
Subscribe to:
Posts (Atom)