how to work out an age from a date of birth
 

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

how to work out an age from a date of birth
 

Suzanne, have a look here,

http://www.cpearson.com/excel/datedif.htm#Age
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Grd" wrote in message
...
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

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

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=

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