Calculating age

N

Neil Chamberland

I need to find a formula that will calculate an age in
years and months. When i use a regular formula I get an
answer (eg 40.8) but this is 40 years and 8/10 months,
what I need is years and months exactly.
 
A

Arvi Laanemets

Hi

=DATEDIF(A1,TODAY(),"Y") & " years " & DATEDIF(A1,TODAY(),"YM") & " months"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
age 3
Expanding Date Formula 0
Calculating Future Value 8
Age Formula 15
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Excel formula calculating age 4
Excel - Calculate age from DOB in years, months days 7

Top