formula to caculate an age

I am needing a formula that would figure out the age in
years and months of a specfic person.
For example
Date of Birth is 7/27/1999 and the date is 10/23/2004 I
would like the the cell to respond as 4-2
4 being the year and 2 being the month.

Have any suggestions?

Gayle

You need the DATEDIF Function.

See Chip Pearson's site for info and usage.

http://www.cpearson.com/excel/datedif.htm

Gord Dibben Excel MVP

On Thu, 29 Apr 2004 15:35:15 -0700, "Gayle"
wrote:

I am needing a formula that would figure out the age in
years and months of a specfic person.
For example
Date of Birth is 7/27/1999 and the date is 10/23/2004 I
would like the the cell to respond as 4-2
4 being the year and 2 being the month.

Have any suggestions?