To calculate age until a specific date

[Guest]

In one list of pupils with varied dates of birth, example: Pupil: 12/01/1998; Pupil B: 08/07/1990; Pupil C: 30/06/1978; Pupil D: 25/11/1991. But he would like that the pupils with anniversary up to 30/06/2004 had the brought up to date age, excessively they would remain with the normal age
Former: Pupil: 6 years, Pupil B: 23 years, Pupil C: 26 years and Pupil D: 12 years

As it would be the formula, function?

 

[Max]

Assume you have in A1:B4 the data below:

Pupil A.12-Jan-98
Pupil B.8-Jul-90
Pupil C.30-Jun-78
Pupil D.25-Nov-91

Put in D1: 30-Jun-04 (the "anniversary date")

Put in C1: =ROUNDUP($D$1-B1,-1)

Select C1

Click Format > Cells > Number tab > Custom > Type: yy

Copy C1 down to C4

C1:C4 will return the desired age of the pupils A - D
as of the "anniversary date"

--
hth
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<at>yahoo<dot>com
for email
-------------------------------------------

In one list of pupils with varied dates of birth, example: Pupil:

12/01/1998; Pupil B: 08/07/1990; Pupil C: 30/06/1978; Pupil D: 25/11/1991.
But he would like that the pupils with anniversary up to 30/06/2004 had the
brought up to date age, excessively they would remain with the normal age.