=IF(AND(MONTH(A1)=MONTH(B1),DAY(A1)=DAY(B1)),YEA R(A1)-YEAR(B1),YEAR(A1)-YEAR(B1)-1)

This says if they entered after their birthday then subtract the two years.
Else subtract 1 from the difference of the two years.

If you are willing to sacrifice accuracy for simplicity, you could use..

=YEAR(A1)-YEAR(B1)

"Alan" wrote:

In cell A1 I have the admission date to a longterm care home- eg.
05/30/2001.
In cell B1 I have the birth date - eg. 02/23/1924.

Can some guru give me a calculation to put in cell C1 that will give me
the age (in years) of the individual when they entered as a resident??

Many thanks in advance,
Alan