Take a look at =datedif().

Chip Pearson has very nice instructions at:
http://www.cpearson.com/excel/datedif.htm



Age calculation in Excel wrote:

I am trying to build a Excel spread sheet and I want to calculate the childs
age starting at 2 weeks of age. Then get month age and then year age.

--

Dave Peterson