ExcelPowerUser
Tuesday, December 27, 2011
Age Calculation :
If Current Date in A1 and Date of Birth in B2 then Put this Function to Calculate Age:
=DATEDIF(B2,B1,"Y")&" Year "&DATEDIF(B2,B1,"YM")&" Month "&DATEDIF(B2,B1,"MD")&" Days"
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment