Wednesday, 16 January 2013

AGE CALCULATION

Birth date : 1-Jan-87
Date from which you want to Calculate:
YEARs 26Years    =DATEDIF(B1,TODAY(),"Y")   For YEARS

MONTH 0 Month   =DATEDIF(B1,TODAY(),"YM")  For MONTHS

DAYS 15 Days        =DATEDIF(B1,TODAY(),"MD")    For DAYS

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)