Dependent Age-Change Year/Month to Year

[frosty3]

I would like to take the dependent age below which is 15yrs, 07mo and change it to just year number (eg 15). How can I do this?

Bobbi

<TABLE style="WIDTH: 218pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=290 border=0><COLGROUP><COL style="WIDTH: 135pt; mso-width-source: userset; mso-width-alt: 6582" width=180><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4022" width=110><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl58 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 135pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=180 height=17>Dependent Date Of Birth</TD><TD class=xl58 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 83pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=110>Dependent Age</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl60 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>03/08/1996</TD><TD class=xl59 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">15yrs, 07mo</TD></TR></TBODY></TABLE>

 

[VoG]

Try like this

=DATEDIF(A1,TODAY(),"y")

 

[frosty3]

Thanks Peter for your help! That worked GREAT!

Bobbi