=HLOOKUP(K2,{16,21,31,41,51,61,71;"16-20","21-30","31-40","41-50","51-60","61-70","71-80"},2)
assuming your first age is in L2, copy formula to K2 and then copy down. If
your list starts further down, adjust as needed.
This formula will give you an N/A error if you have anyone under 16 and will
put everyone over 71 in the 71-80 age group. If there is any chance you
might have someone outside of the ranges you gave, this formula will add <16
for anyone under 16 and 80 for anyone over 80:
=HLOOKUP(K2,{0,16,21,31,41,51,61,71,81;"<16","16-20","21-30","31-40","41-50","51-60","61-70","71-80","80"},2)

"Donna" wrote:

In column K I have ages calculated from birthdates.

In Column L I would like to translate these ages into age groups, from which
I will later create a pivot chart to show the frequency of each age group.

I need a formula to translate the ages in Column K into age ranges in Column
L (16-20, 21-30, 31-40, 41-50, 51-60, 61-70, 71-80).

Can anyone tell me in layman's terms how this can be done and what I need to
enter where?

Thanks for reading!