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

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

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

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


"Marge" wrote:

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

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

"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