I have a list of birthdays 11/17/1975 on cell A1 and 11/17/2010 on cell B1...
on C1 I have this formula:

=INT(YEARFRAC(TODAY(),A,1,1)) which makes the age 34 (if i format the cell to
General or number)

...It tells me what age this person is but if I change the date on B1 to
11/17/2011 (for example), it wont change the age on C1 to 35...

What is the formula to do this change?

Thanks,
Trish

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tacts/201003/1