Saturday 28 December 2013

HOW TO FIND OUT YOUR AGE
THROUGH AGE FORMULA
IN MICROSOFT EXCEL

TO FIND OUT THE YEARS
=DATEDIF(CELL # IN WHICH DATE OF BIRTH IF WRITTEN,TODAY(),"Y")
SUPPOSE THE CELL # IS B4, THEN
=DATEDIF(B4,TODAY(),"Y")
SIMILARLY TO FIND OUT MONTHS
=DATEDIF(B4,TODAY(),"YM")
TO FIND OUT DAYS
=DATEDIF(B4,TODAY(),"MD"



No comments:

Post a Comment