Require forumla to calculate age at date of termination

Hi

I need a formula to calcuate an employees age based on their date of birth at date of termination (information in two other cells).

Example:

In Cell D7 is the persons Date of Birth

In Cell D10 is their termination date

I need a formula in Cell G6 to calculate what age they will be at their date of termination?

I have attached an example workbook to hopefully explain better - example.xls

Please help!

Thanks

Stacey

This will give your their age based on the data in the two cells.

=DATEDIF(D7,$D$10,"y") & " Yrs, " & DATEDIF(D7,$D$10,"ym") & " Mnths "

This will give your their age based on the data in the two cells.

=DATEDIF(D7,$D$10,"y") & " Yrs, " & DATEDIF(D7,$D$10,"ym") & " Mnths "