Let say your
A1 8/16/1979
A2 8/16/2007

A3 =DATEDIF(A1,A2,"y")

---------------------
mama no teeth

"Mert" wrote:

I want to calculate someone's age from a year not from today's date.

ie: the birthday is August 16, 1979 if we calculate from (today) it will
say 27 but i want to calculate from the year (2007) - so it will show 28