Calculate age

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grd - 28 Feb 2007 15:23 GMT

Hi there,

How do I calcuate the age of a person if all I have is their date of birth
in a cell?

Is this possible in excel?

Thanks for your help

Suzanne

Reply to this Message

JE McGimpsey - 28 Feb 2007 15:35 GMT

One way:

=DATEDIF(A1,TODAY(),"y")

See

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

for more options.

> Hi there,
>
[quoted text clipped - 6 lines]
>
> Suzanne

Reply to this Message

Mike - 28 Feb 2007 15:37 GMT

with the DOB in A1 try

=DATEDIF(A1,TODAY,"Y") & " Years, " & DATEDIF(A1,TODAY,"YM") & " Months, " &
DATEDIF(A1,TODAY,"MD") & " Days"

> Hi there,
>
[quoted text clipped - 6 lines]
>
> Suzanne

Reply to this Message

JE McGimpsey - 28 Feb 2007 15:52 GMT

Note that you need to be careful with this:

First, TODAY should be TODAY(), unless TODAY is a name in the workbook.

Second, given the way the "md" switch works, calculations are based on
the length of the first month. so:

A1: 31 January 2007
A2: 1 March 2007
A3: =DATEDIF(A1,A2,"Y") & " Years, " & DATEDIF(A1,A2,"YM") & "
Months, " & DATEDIF(A1,A2,"MD") & " Days"

returns

0 Years, 1 Months, -2 Days

in A3. That's usually not what is desired.

> with the DOB in A1 try
>
> =DATEDIF(A1,TODAY,"Y") & " Years, " & DATEDIF(A1,TODAY,"YM") & " Months, " &
> DATEDIF(A1,TODAY,"MD") & " Days"

Reply to this Message

Mike - 28 Feb 2007 15:53 GMT

sorry typo

=DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months,
" & DATEDIF(A1,TODAY(),"MD") & " Days"

> with the DOB in A1 try
>
[quoted text clipped - 11 lines]
> >
> > Suzanne

Reply to this Message