How can I calculate "age" from columns of dates rather than individual
rows(single case) either using the following functions COUNTIF, YEARFRAC,
DATEDIF or YEAR

Why can't you just use

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

in a cell and copy it down for as many rows as you need to go.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



On Wed, 28 Apr 2010 10:58:01 -0700, LOUIDEME
wrote:

How can I calculate "age" from columns of dates rather than individual
rows(single case) either using the following functions COUNTIF, YEARFRAC,
DATEDIF or YEAR

Many thanks for your reply,but I have not been able to solve my problem based on it. Copying the function to the following cells in a column would not work since the cell designation in the formula would be different (A2,A3,A4,A5...). The other complication is that the age ceiling is not "today" but a variety of dates...(the table concerns age at the time of admission into hospital

DATE O BIRTH DATE O ADMISSION
12/02/1987 03/11/2008
08/12/1965 21/04/1999

Many thanks for your help



LOUIDEME wrote:

Calculation of Age
28-Apr-10

How can I calculate "age" from columns of dates rather than individual
rows(single case) either using the following functions COUNTIF, YEARFRAC,
DATEDIF or YEAR

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
BizTalk: Incorporating conditional If / Else Functoid Logic in a map.
http://www.eggheadcafe.com/tutorials...rating-co.aspx

Maybe...

=DATEDIF(A2,B2,"y")



Sergio, De, Moura wrote:

Many thanks for your reply,but I have not been able to solve my problem based on it. Copying the function to the following cells in a column would not work since the cell designation in the formula would be different (A2,A3,A4,A5...). The other complication is that the age ceiling is not "today" but a variety of dates...(the table concerns age at the time of admission into hospital

DATE O BIRTH DATE O ADMISSION
12/02/1987 03/11/2008
08/12/1965 21/04/1999

Many thanks for your help

LOUIDEME wrote:

Calculation of Age
28-Apr-10

How can I calculate "age" from columns of dates rather than individual
rows(single case) either using the following functions COUNTIF, YEARFRAC,
DATEDIF or YEAR

Previous Posts In This Thread:

Submitted via EggHeadCafe - Software Developer Portal of Choice
BizTalk: Incorporating conditional If / Else Functoid Logic in a map.
http://www.eggheadcafe.com/tutorials...rating-co.aspx

--

Dave Peterson