G
goju
i am trying to automaticallly generate a letter which is determined by
date of birth,
if in column a the date of birth is 01/01/00, then i need column b to
automatically identiyfy that the person is under 16 years of age and
put the letter J in column b
If the date was 01/01/89 (ithink thats right) then i need column b to
identyfy that ther person is 16 and over and the column automatically
put the letter S
the below formula i used on an old spread sheet but this was determined
by years and not the date of birth.
Any ideas how to solve this???
=IF(X19>16,"S","J")
By the way X19 was the amount of years.
date of birth,
if in column a the date of birth is 01/01/00, then i need column b to
automatically identiyfy that the person is under 16 years of age and
put the letter J in column b
If the date was 01/01/89 (ithink thats right) then i need column b to
identyfy that ther person is 16 and over and the column automatically
put the letter S
the below formula i used on an old spread sheet but this was determined
by years and not the date of birth.
Any ideas how to solve this???
=IF(X19>16,"S","J")
By the way X19 was the amount of years.