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