age calculation
 

I am trying to find a calculation for "how old will this person be on this
date"

example: Johnny was born 08/10/1910 and I want to know as of 07/01/2005 how
old Johnny will be, without rounding up.

Answer: 94 years old

Is this even possible?

http://www.xldynamic.com/source/xld.html

Regards,

Peo Sjoblom

"Teapot" wrote:

I am trying to find a calculation for "how old will this person be on this
date"

example: Johnny was born 08/10/1910 and I want to know as of 07/01/2005 how
old Johnny will be, without rounding up.

Answer: 94 years old

Is this even possible?

Oops. Old address still in memory

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

is the correct one

Regards,

Peo Sjoblom

"Peo Sjoblom" wrote:

http://www.xldynamic.com/source/xld.html

Regards,

Peo Sjoblom

"Teapot" wrote:

I am trying to find a calculation for "how old will this person be on this
date"

example: Johnny was born 08/10/1910 and I want to know as of 07/01/2005 how
old Johnny will be, without rounding up.

Answer: 94 years old

Is this even possible?