View Single Post
  #2   Report Post  
Chris Rogers
 
Posts: n/a
Default

Put the measurement in a cell (i'll use D1)
Put the DOB in Cells D2 and below

To calculate the age of the person on line 2, enter the formula D$1-D2
in Cell E2
Format Cell E2 to be Custom and use the masking of YY