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"



28 Dec 2013

0 comments:

Post a Comment

:) :)) ;(( :-) =)) ;( ;-( :d :-d @-) :p :o :>) (o) [-( :-? (p) :-s (m) 8-) :-t :-b b-( :-# =p~ $-) (b) (f) x-) (k) (h) (c) cheer
Click to see the code!
To insert emoticon you must added at least one space before the code.

 
Top