Date-Years-Age of person

[Guest]

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

 

[Bob Phillips]

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)

 

[Stan Brown]

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

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

 

[Bob Phillips]

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)