caculate a persons age
 

What function do I use to caculate someones age

caculate a persons age
 

Hi

=DATEDIF(BirthDate,TODAY(),"y")
to get the current age in years.

=DATEDIF(BirthDate,TODAY(),"ym")
to get months over full years.

=DATEDIF(BirthDate,TODAY(),"y")
to get days over full months.

(there may be some inaccuracies due variable month lengths for last 2
formulas for specific dates as function 2 first parameters).


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Dave" wrote in message
...
What function do I use to caculate someones age

caculate a persons age
 

See this:

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

Biff

"Dave" wrote in message
...
What function do I use to caculate someones age