Thread: caculate a persons age
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
  
Posts: 510
Default 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


Reply With QuoteReply With Quote