Thread: how to work out an age from a date of birth
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default how to work out an age from a date of birth
If the birthday is in A1, then:

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

--
Gary's Student


"Grd" wrote:

Hi there,

Is it possible to work out the date with a function perhaps say if the date
of birth is 22/7/71 then the person is 35?

Thanks for any help

Regards

Suzanne
Reply With QuoteReply With Quote