age calculation in Excel

[John Grinstead]

Dear All,

I am always pleasantly surprised by how many knowledgeable and
helpful folks there are on this list. Thanks again for your help,
especially:

Barbara Zurer Pearson
Yvan Rose
Brian MacWhinney
Neil Bohannon
Susan Gelman
Keiko Okada

Most especially, I would like to thank Sonja Bartels, who provided me
with this function which can be pasted into an Excel spreadsheet:

=DATEDIF(A2,B2,"y") & ";" & DATEDIF(A2,B2,"ym") & "." & DATEDIF(A2,B2,"md")

which will produce an age like "7;3.7" in column C, if you enter
birthdates like "4-15-95" in column A and testing dates like
"7-22-02" in column B.

Thanks again, all, so much,

John




***********************
John Grinstead
Assistant Professor
Department of Modern Languages
Baker 271
University of Northern Iowa
Cedar Falls, Iowa  50614-0504

Tel. (319)273-2417
Fax. (319)273-2848
John.Grinstead at uni.edu
***********************