Prev: entering parameter criteria MS Query
Next: Excel VBA 'Help'
From: Sergio De on 29 Apr 2010 07:48
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/aspnet/f6fc20ab-5c6a-4f04-8a0b-bba39e4bbcf0/biztalk-incorporating-co.aspx
From: Dave Peterson on 29 Apr 2010 07:59
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/aspnet/f6fc20ab-5c6a-4f04-8a0b-bba39e4bbcf0/biztalk-incorporating-co.aspx

--

Dave Peterson
 | 
Pages: 1
Prev: entering parameter criteria MS Query
Next: Excel VBA 'Help'