View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default how to work out an age from a date of birth

=YEAR(7/22/71)+35 will give you the year the person turns 35. Make sure the
cell in which this formula is placed is formatted as a number.

(I'm using the MM/DD/YY format above. You should be able to use your date
format below).

Dave
--
Brevity is the soul of wit.


"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=