people ages

[tom]

I'm using excel and inputting dates of birth in the
following format
dd/mm/yyyy.

I also have a column for age. How do i get the age
(using todays date) of
every person using a formula?


D.O.B. Age
example: 11/04/1982 22

 

[NH]

UseROUND((TODAY()-C4)/365,0)
Assuming C4 is the cell where the birth date is stored

 

[Don Guillett]

try
=DATEDIF(K6,TODAY(),"Y")

 

[Gord Dibben]

Tom

DATEDIF was described only in Excel 2000 but is available in many versions of
Excel, including 2000.

You do not need any add-ins, should work with normal setup.


=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " &
DATEDIF(A1,NOW(),"md") & " days"

The above formula will return a string like 42 years, 9 months, 26 days

A1 holds the earliest date.

For more on DATEDIF see Chip Pearson's site.

http://www.cpearson.com/excel/datedif.htm

There are some caveats with DATEDIF.

From a posting by John McGimpsey.........................

However, be very careful about days - DATEDIF() assumes that a month is
as long as the number of days in the first date's month, so if

A1 = 31 January 1980

on 1 March 2005, the result will be:

Age is 25 Years, 1 Months and -2 Days

Some people may not feel -2 days is valid.

Gord Dibben Excel MVP