Age for date
 

Hi,

Don't use excel much so please be gentle. Am fairly sure this particular
query has been dealt with before but don't have time to sift through
thousands of posts.

Anyway, have date of birth in one column (E), would like the age to be
automatically displayed and updated in another (G). Seemed gobsmackingly
simple to start with but haven't been able to get the right formula.

Please help!

Jim

Age for date
 

Assuming that A1 contains the birthday:
=DATEDIF(A1,NOW(),"y")

Cheers,
JM

"Jim Nicholas" wrote in message
...
Hi,

Don't use excel much so please be gentle. Am fairly sure this particular
query has been dealt with before but don't have time to sift through
thousands of posts.

Anyway, have date of birth in one column (E), would like the age to be
automatically displayed and updated in another (G). Seemed gobsmackingly
simple to start with but haven't been able to get the right formula.

Please help!

Jim

Age for date
 

Hi,

Try this

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

Have a look here for an explanation of datedif

http://www.cpearson.com/excel/datedif.aspx

Mike

"Jim Nicholas" wrote:

Hi,

Don't use excel much so please be gentle. Am fairly sure this particular
query has been dealt with before but don't have time to sift through
thousands of posts.

Anyway, have date of birth in one column (E), would like the age to be
automatically displayed and updated in another (G). Seemed gobsmackingly
simple to start with but haven't been able to get the right formula.

Please help!

Jim