How to calculate age in excel.

Pages : 1

Rahul Sharma
----------

[ Scorecard : 8065]

Posted On 08 February 2012 at 12:12

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 :

=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

Related Files

Sign-in to your account

Sign-up now

How to calculate age in excel.

Related Files

Related Threads

Post your reply for How to calculate age in excel.

Message