=CHOOSE(INT(I4/10),"","20-29","30-39","40-49","50-59","60-69")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Sue" wrote in message
...
I need to flag ee who are between the ages of 20-29, 30-39, 40-49, 50-59,
and
60-69

what would the formual look like just using years eg born between 1976 and
1967 etc...

Thank you
hopeless