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