i need a formula that calculates current age on a daily basis?

[Marge]

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....

 

[Mike H]

Marge,

The simplest gives the age in years

=DATEDIF(A1,TODAY(),"Y")

To get a more detailed age

=DATEDIF(A1,today(),"Y")&" Years "&DATEDIF(A1,Today(),"YM")&" Months
"&DATEDIF(A1,today(),"MD")&" Days"

The last formula while mostly reliable can throw anomolies, try this dates

31 Jan 1951
01 Mar 2008
which gives
57 years, 1 months, -1 days

For that reason you may want this

=DATEDIF(A1,today(),"Y")&" Years "&DATEDIF(A1,today(),"YD")&" Days"

Datedif isn't documented in Excel, for help look here

http://www.cpearson.com/excel/datedif.aspx

Mike

 

[Bill Ridgeway]

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