Age from birthday

[Hildo]

This shouyld be easy, but I can't seem to figure it out.

I have the birthday of a client and I need his age in
years.

Somebody has a formula?

TAI,
Hildo

PS: I tried to look in the past messages but got a lot
of 'message unvailable'.

 

[Andy Brown]

You can use DATEDIF, eg:

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

with DOB in A1.

Rgds,
Andy

 

[JS]

Hi - Try the following function...

Function CalcAge(Start)
CalcAge = Int((DateDiff("m", Start, Now)) / 12)
End Function

 

[Thomas]

datedif(a1,now(),"Y")
A1 would be the cell the persons birthday is in.

 

[Paul B]

Hildo, here is some more info on datedif
http://www.cpearson.com/excel/datedif.htm#Age

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **