1 way is:

=NOW()-DATE(1956;11;23)

format cells as custum yy


"sparty" skrev:


I have a spreadsheet in which I have one column where I enter a persons
D.O.B. and in the next column it contains the formula to work out and
display their age, however I'd like to be able to just enter the D.O.B.
and for the age to be calculated and displayed in the same column as the
info is entered, is this at all possible?


--
sparty
------------------------------------------------------------------------
sparty's Profile: http://www.excelforum.com/member.php...o&userid=31306
View this thread: http://www.excelforum.com/showthread...hreadid=563674