Tuesday, March 25, 2014

yogi_Given Birthday And Test Day Date Compute Age In Years As Of Today And As Of Test Date

                                         Google Spreadsheet   Post  #1572
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-25-2014
post by Eileen Rasmussen  (https://productforums.google.com/forum/#!mydiscussions/docs/lOLvSROOiNU)
Sheets formula for subject age at time of testing
Hey all,

So I've Googled this pretty well and come across a few similar questions, but none of the suggested formulas have been working.

Basically, we have a biiiig google excel sheet with some subject data, and we want a column that shows each subject's age at the time they were tested. Each subject already has a cell that has the date they were tested, and their birthday.

When I try:
Where A1 date tested and A2 is birthdate? 

Where A8 is date tested and B8 is birthdate

I get parse errors. Not sure why.

+ a few other formulas have yet to work.

 I cannot for the life of me get this to work, although it seems so simple! Haaaalp :(

Thanks in advance!