Discussion > Info Technology > Excel >

# How to calculate age in excel.

Pages : 1

----------

[ Scorecard : 8065]

You can calculate a persons age based on their birthday and todays date.

The calculation uses the DATEDIF() function.

The DATEDIF() is not documented in Excel 5, 7 or 97, but it is in 2000.

(Makes you wonder what else Microsoft forgot to tell us!)

Birth date :29-Apr-73

 Years lived : 38 =DATEDIF(C8,TODAY(),"y") and the months : 9 =DATEDIF(C8,TODAY(),"ym")
 and the days : 7 =DATEDIF(C8,TODAY(),"md")

You can put this all together in one calculation, which creates a text version.
Age is 38 Years, 9 Months and 7 Days
="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days"

Another way to calculate age

This method gives you an age which may potentially have decimal places representing the months.
If the age is 20.5, the .5 represents 6 months.

 Birth date : 01-Jan-60 Age is : 52.10
=(TODAY()-C23)/365.25

Member (Account Deleted)
CA Final Student

[ Scorecard : 182]
Posted On 12 June 2012 at 11:05

Good one buddy

There are 1 Replies to this message

### Message

• Use thank button to convey your appreciation.
• Maintain professionalism while posting and replying to topics.