Calculating present age if date of birth is given.

harsh_njoy · Jul 25, 2008

Hi,

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

Thanks

NoodNutt · Jul 25, 2008

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 · Jul 25, 2008

Try

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

Where A1 is the date of birth

Mike

Joerg Mochikun · Jul 25, 2008

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

Calculating age from date of birth and ignoring if blank	5	Nov 24, 2010
"how do I calculate age by using date of birth details"	5	Feb 14, 2009
Calculating age of death	23	Feb 21, 2008
Calculating Age	6	Aug 10, 2005
formula to calculate age using birth date and current date	2	Nov 20, 2005
Formula to Return age	2	Apr 8, 2010
Calculating age from birth dates	4	Sep 8, 2003
calculate date of birth with an end date and age	1	Jan 7, 2010

Calculating present age if date of birth is given.

harsh_njoy

NoodNutt

Mike H

Joerg Mochikun

Ask a Question

Similar Threads