Date-Years-Age of person
 

I insterted a formula that calculated (Or should have done) for students ages
ata a certain date

I.e need to know if students would be 19 on the 31/8/07

I used =year(31/8/2007)-year(6/9//1988) cell references. The answer came
back 19 years old but of course student would only be 18 on the 31/8/07. I
assume it counts the whole year but need to determine exact age

Thanks

Steve King

Date-Years-Age of person
 

Use

=DATEDIF(A1,DATE(2007,8,31),"y")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"K11ngy" wrote in message
...
I insterted a formula that calculated (Or should have done) for students
ages
ata a certain date

I.e need to know if students would be 19 on the 31/8/07

I used =year(31/8/2007)-year(6/9//1988) cell references. The answer came
back 19 years old but of course student would only be 18 on the 31/8/07.
I
assume it counts the whole year but need to determine exact age

Thanks

Steve King

Date-Years-Age of person
 

Mon, 9 Jul 2007 10:11:24 +0100 from Bob Phillips
:

"K11ngy" wrote in message
...
I insterted a formula that calculated (Or should have done) for students
ages at a a certain date

I used =year(31/8/2007)-year(6/9//1988) cell references. The
answer came back 19 years old but of course student would only be
18 on the 31/8/07. I assume it counts the whole year but need to
determine exact age

Use

=DATEDIF(A1,DATE(2007,8,31),"y")

Just a heads-up: you probably won't find this in Excel help. See Chip
Pearson's article at
http://cpearson.com/excel/datedif.htm

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Date-Years-Age of person
 

It's in Excel 2000 help, but not any other (sic!).

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Stan Brown" wrote in message
...
Mon, 9 Jul 2007 10:11:24 +0100 from Bob Phillips
:

"K11ngy" wrote in message
...
I insterted a formula that calculated (Or should have done) for students
ages at a a certain date

I used =year(31/8/2007)-year(6/9//1988) cell references. The
answer came back 19 years old but of course student would only be
18 on the 31/8/07. I assume it counts the whole year but need to
determine exact age

Use

=DATEDIF(A1,DATE(2007,8,31),"y")

Just a heads-up: you probably won't find this in Excel help. See Chip
Pearson's article at
http://cpearson.com/excel/datedif.htm

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/