Prev: Round Date & Time
Next: Help!!!!!!
From: LOUIDEME on 28 Apr 2010 13:58
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
From: Chip Pearson on 28 Apr 2010 14:23
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
<LOUIDEME(a)discussions.microsoft.com> 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
 | 
Pages: 1
Prev: Round Date & Time
Next: Help!!!!!!