Thread: Calculate age
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Calculate age

One way:

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

See

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

for more options.

In article ,
Grd wrote:

Hi there,

How do I calcuate the age of a person if all I have is their date of birth
in a cell?

Is this possible in excel?

Thanks for your help

Suzanne