Thread: how to work out an age from a date of birth
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
  
Posts: 1,047
Default how to work out an age from a date of birth
hi,

assuming the 22/7/71 is on a1

=datedif(a1,today(),"y")

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Grd" escreveu:

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