Calculating present age if date of birth is given.
 

Hi,

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

Thanks

Calculating present age if date of birth is given.
 

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.

Calculating present age if date of birth is given.
 

Try

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

Where A1 is the date of birth

Mike

"harsh_njoy" wrote:

Hi,

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

Thanks

Calculating present age if date of birth is given.
 

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")
--
David Biddulph

"NoodNutt" wrote in message
...
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.

Calculating present age if date of birth is given.
 

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
hehttp://www.cpearson.com/excel/datedif.aspx

Cheers,

Joerg Lefeber



"harsh_njoy" wrote in message
...
Hi,

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

Thanks