Thread: Calculating age
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
claude jerry claude jerry is offline
external usenet poster
 
Posts: 70
Default Calculating age

A1 = birth date
B1 = Today()

in C1 enter this = =DATEDIF(A1,B1,"Y")

for more detailed age try this
=DATEDIF(A1,B1,"Y")&" Years "&DATEDIF(A1,B1,"YM")&" Months
"&DATEDIF(A1,B1,"MD")&" Days"


"Pascale" wrote:

Could you please tell me how I could have in column C, the age of a person
from indicating (column A)the birthdate and the other (column B) today's
date. Many thanks ahead