"Brian" wrote :
....
The part the I need know is to subtract 2 dates from each other
to get the age. The dates are preset. Also how can I get the whole
numbers for the age and not to get the rounded up number.

Perhaps something along these lines ..

Assume you have in A1:B4 the data below,
names in col A, dates of birth in col B:

Pupil A 12-Jan-1998
Pupil B 08-Jul-1990
Pupil C 30-Jun-1978
Pupil D 25-Nov-1991

And in say, D1, you have a certain pre-set reference date,
say an "anniversary date": 30-Jun-2005

Put in C1: =TEXT(ROUNDUP($D$1-B1,-1),"y")+0
Format C1 as: General or Number (zero dp)

Copy C1 down to C4

C1:C4 will return the age of the pupils A - D
as of the "anniversary date"
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----