View Single Post
  #4   Report Post  
Alan
 
Posts: n/a
Default

Try
=(A1-B1)/365.25
Format as a number,
Regards,
Alan.
"Alan" wrote in message
. ..
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