calculate the age of someone at a MRI scan visit if I am given their date of birth and the date of the scan
To what precision, or in what units?
To just get the age in years, try
Let ( [
dob = dateVisit ;
scan = dateScan ;
Year ( scan ) - Year ( dob ) - ( Month ( scan ) < Month ( dob ) or Day ( scan ) < Day ( dob ) )
In years, months, and days. Thanks, this is helpful so far!