Automatic updating of age groups columns

's Computer Specifications

nUsing XP Home/ Office 2000.
I have two colums of students, column 'A' contains D.O.B, column 'B''
contains students age.
Has anyone a formula so that Column B will automatically update the students
age rather than having to manually update the current age of each student?
Thanks in advance.

's Computer Specifications

One way:

B2: =DATEDIF(A2,TODAY(),"y")

In article <76A77D6F-0E4B-4FF9-82FC-(E-Mail Removed)>,
Paul JJ Adams <(E-Mail Removed)> wrote:

> nUsing XP Home/ Office 2000.
> I have two colums of students, column 'A' contains D.O.B, column 'B''
> contains students age.
> Has anyone a formula so that Column B will automatically update the students
> age rather than having to manually update the current age of each student?
> Thanks in advance.

's Computer Specifications

Maybe this in b1 and drag down

=DATEDIF(A1,NOW(),"y") & " y, " & DATEDIF(A1,NOW(),"ym") & " m, " &
DATEDIF(A1,NOW(),"md") & " d"

Mike

"Paul JJ Adams" wrote:

> nUsing XP Home/ Office 2000.
> I have two colums of students, column 'A' contains D.O.B, column 'B''
> contains students age.
> Has anyone a formula so that Column B will automatically update the students
> age rather than having to manually update the current age of each student?
> Thanks in advance.

's Computer Specifications

Note that this produces some weird results...

For instance on 3/1/2008:

A2: 1/31/1990
B2: 18 y, 1 m, -1 d

Also - never need to use NOW() rather than TODAY() - the time portion
just gets thrown away.

In article <51E01E5D-23FA-4ED4-B314-(E-Mail Removed)>,
Mike H <(E-Mail Removed)> wrote:

> Maybe this in b1 and drag down
>
> =DATEDIF(A1,NOW(),"y") & " y, " & DATEDIF(A1,NOW(),"ym") & " m, " &
> DATEDIF(A1,NOW(),"md") & " d"

's Computer Specifications

Thanks for that, I never new about the spurious results

"JE McGimpsey" wrote:

> Note that this produces some weird results...
>
> For instance on 3/1/2008:
>
> A2: 1/31/1990
> B2: 18 y, 1 m, -1 d
>
>
> Also - never need to use NOW() rather than TODAY() - the time portion
> just gets thrown away.
>
>
> In article <51E01E5D-23FA-4ED4-B314-(E-Mail Removed)>,
> Mike H <(E-Mail Removed)> wrote:
>
> > Maybe this in b1 and drag down
> >
> > =DATEDIF(A1,NOW(),"y") & " y, " & DATEDIF(A1,NOW(),"ym") & " m, " &
> > DATEDIF(A1,NOW(),"md") & " d"
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Option Groups, and updating	=?Utf-8?B?UlN0ZXBo?=	Microsoft Access	3	9th Aug 2007 11:16 PM
Updating Groups of Records via a Form	SplitEdgeMan	Microsoft Access Queries	1	16th Oct 2005 11:49 AM
sort groups of 2 columns independently from other groups	=?Utf-8?B?ZGF3bg==?=	Microsoft Access Reports	3	18th Jul 2005 05:12 PM
Updating AD Groups via a Web page	louey-3@excite.com	Microsoft Windows 2000 Active Directory	1	17th Mar 2005 01:59 PM
updating formulas in groups	flya	Microsoft Excel Worksheet Functions	1	29th Jul 2004 03:11 PM