Calculating projected age

**NancyNo5** · 01-16-2013, 01:13 PM

I need the formula to calculate the projected age of an individual. For example, if someone is born Feb. 14 1999, how old will they be in 2019.

Thank you.

**Pete_UK** · 01-16-2013, 01:25 PM

What date in 2019?

Pete

**NancyNo5** · 01-16-2013, 01:58 PM

September 1, 2019

**Kevin UK** · 01-16-2013, 02:03 PM

Hi

Assuming DOB in A1 and the future date in A2, this will give you years.

Formula:

Please Login or Register  to view this content.

And years and months.

Formula:

Please Login or Register  to view this content.

Re: Calculating projected age