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