"Marge" wrote in message
...
basically I'm setting a spreadsheet for a waiting list for children to
join a
group, and I'm doing it on age order and I need a formula to show me what
age
the children are at a given time....

=(TODAY()-A1)/365
where the birthday is in A1

It doesn't take account of the fact that a year is actually completed the
day preceding a birthday or that some years have 366 days but it will do the
job.

Bill Ridgeway