Brian,

This might help:

Cell A2: DOB such as 15/06/1961
Cell B2: You cannot have current age and current date together in one
column
Instead Cell B2: Today's date 03/08/2005
Subtracting Current date (or some other date in the future) from DOB is
a simple calculation: =b3-a2
You then need to format this cell to express the answer in whole (not
rounded up) years. To do this: Format/Custom and enter in the box the
following: YY
This will express the cell in years only

Hope this solves it for you!

Cheers


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=392409