I want to use the entry forms, but I only want to know the year of birth. How can I get TScore to accept the revised format?
First, unprotect the entry form (password ‘barani’).
Next change the format of the DoB cells to be Numeric, with 0 decimal places.
Next change the Validation rules on these cells to be a range check (say, 1050 to 2010).
Now edit the formula for the Age cells, by removing the occurrences of “YEAR(“ and the matching “)”.
For example:
=IF(INDIRECT(“E”&ROW())=””,””,IF(INDIRECT(“G”&ROW())=””,INDIRECT(“Lists!L”&($I$3-YEAR(INDIRECT(“E”&ROW())))),HLOOKUP(INDIRECT(“G”&ROW()),GradeAges,($I$3-YEAR(INDIRECT(“E”&ROW()))),FALSE)))
Becomes:
=IF(INDIRECT(“E”&ROW())=””,””,IF(INDIRECT(“G”&ROW())=””,INDIRECT(“Lists!L”&($I$3- INDIRECT(“E”&ROW()))),HLOOKUP(INDIRECT(“G”&ROW()),GradeAges,($I$3-INDIRECT(“E”&ROW())),FALSE)))
(You can do this for the first row, then copy it into all the others).