Can't you just do =DATEDIF(8/16/07,8/16/79)?

Dave
--
Brevity is the soul of wit.


"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