Calculating present age if date of birth is given.

[harsh_njoy]

Hi,

how we can calculate present age if date of birth is given say for eg:
21/2/1983

Thanks

 

[NoodNutt]

G'day Harsh

Assume

A1 = Birthdate = 06-Mar-1960 Format as Date
B1 = Now() = 25-Jul-2008 Format as Date
C1 = (B1-A1)/365 = 48yo Format as Number

HTH
Mark.

 

[Mike H]

Try

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

Where A1 is the date of birth

Mike

 

[David Biddulph]

That would be fine if all years were 365 days, Mark.
For a value of 30 Jul 1960 in A1, that returns 48 years and a bit besides.

Try =DATEDIF(A1,B1,"y") or =DATEDIF(A1,TODAY(),"y")

 

[Joerg Mochikun]

Assuming that A1 contains the birthday:
=DATEDIF(A1,NOW(),"y")

For more information on DATEDIF have a look at your *very* old Excel
documentation (yes, Excel once came with printed handbooks) or look
here:http://www.cpearson.com/excel/datedif.aspx

Cheers,

Joerg Lefeber