It worked! Awesome! Thanks for the help--you made my day!
--NavyPianoMan

"T. Valko" wrote:

Excel isn't rounding the result. You're subtracting the calander year
numbers 1983 from 2007. The months/days are ignored. To find the age using
full years try this:

=DATEDIF(birth_date,NOW(),"y")

See this for more info on DATEDIF:

http://cpearson.com/excel/datedif.htm

--
Biff
Microsoft Excel MVP


"NavyPianoMan" wrote in message
...
I tried using (for example) "=YEAR(D6)-YEAR(E6)" to determine someone's
exact
age based on their birthdate and today's date (formatted military-style as
dd-mmm-yy). In the example below, the above formula produces an incorrect
answer because it seems to round up.
Subtracting the following two dates YEAR(28-Aug-07)-YEAR(17-Sep-83)
produces
the number "24", which is correct when you go by the year "yy", but
actually
incorrect because this person isn't actually 24 years old until 17-Sep-07.
Why does EXCEL seem to round up?