PC Review


Reply
Thread Tools Rate Thread

How do I calculate a persn's age in years & months in Excel?

 
 
=?Utf-8?B?TG11cnJheg==?=
Guest
Posts: n/a
 
      30th Jun 2007
I need to calculate a person's age at a given date in years and months (ie
not 23.8years).

If I cannot calculate in yeras and months I need to be able to round down
the year (ie if age comes out at 23.8 I need it to display 23 NOT 24)

Date of birth in column A, other date in column C

Thank-you

 
Reply With Quote
 
 
 
 
=?Utf-8?B?Um9uIENvZGVycmU=?=
Guest
Posts: n/a
 
      30th Jun 2007
See Chip Pearson's coverage of the DATEDIF function:
http://www.cpearson.com/excel/datedif.htm

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Lmurraz" wrote:

> I need to calculate a person's age at a given date in years and months (ie
> not 23.8years).
>
> If I cannot calculate in yeras and months I need to be able to round down
> the year (ie if age comes out at 23.8 I need it to display 23 NOT 24)
>
> Date of birth in column A, other date in column C
>
> Thank-you
>

 
Reply With Quote
 
=?Utf-8?B?TWF4?=
Guest
Posts: n/a
 
      30th Jun 2007
One way

In say, D2:
=IF(OR(A2="",C2=""),"",DATEDIF(A2,C2,"y"))
Copy down to return the years.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lmurraz" wrote:
> I need to calculate a person's age at a given date in years and months (ie
> not 23.8years).
>
> If I cannot calculate in yeras and months I need to be able to round down
> the year (ie if age comes out at 23.8 I need it to display 23 NOT 24)
>
> Date of birth in column A, other date in column C
>
> Thank-you
>

 
Reply With Quote
 
Rick Rothstein \(MVP - VB\)
Guest
Posts: n/a
 
      30th Jun 2007
>I need to calculate a person's age at a given date in years and months (ie
> not 23.8years).
>
> If I cannot calculate in yeras and months I need to be able to round down
> the year (ie if age comes out at 23.8 I need it to display 23 NOT 24)
>
> Date of birth in column A, other date in column C


This should do it...

=DATEDIF(A1,C1,"y")&" years, "&DATEDIF(A1,C1,"ym")&" months"

although months don't switch over until the actual day. That is, for today
(June 30, 2007), someone born on January 30th or earlier will show X years
and 5 months; but if they were born on January 31st, they would show as X
years and 4 months... the 4 wouldn't become 5 until tomorrow (one day later
when the days match up).

Rick


 
Reply With Quote
 
=?Utf-8?B?TG11cnJheg==?=
Guest
Posts: n/a
 
      16th Jul 2007
This was extremely helpful.

"Ron Coderre" wrote:

> See Chip Pearson's coverage of the DATEDIF function:
> http://www.cpearson.com/excel/datedif.htm
>
> Does that help?
> ***********
> Regards,
> Ron
>
> XL2002, WinXP
>
>
> "Lmurraz" wrote:
>
> > I need to calculate a person's age at a given date in years and months (ie
> > not 23.8years).
> >
> > If I cannot calculate in yeras and months I need to be able to round down
> > the year (ie if age comes out at 23.8 I need it to display 23 NOT 24)
> >
> > Date of birth in column A, other date in column C
> >
> > Thank-you
> >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Calculate age from DOB in years, months days Polly Microsoft Excel Worksheet Functions 7 11th Feb 2010 10:21 AM
Calculate age in years and months MrsRum@gmail.com Microsoft Access 3 10th Oct 2008 08:00 PM
Calculate Age in Years and Months? =?Utf-8?B?R3Jk?= Microsoft Excel New Users 1 15th Feb 2006 05:07 PM
Calculate months and years =?Utf-8?B?TmVkIEx1ZGQ=?= Microsoft Excel Misc 5 10th Dec 2004 01:57 PM
CALCULATE YEARS AND MONTHS =?Utf-8?B?eXZvbm5lYg==?= Microsoft Excel Worksheet Functions 2 28th Aug 2004 02:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:15 AM.