#1   Report Post  
rocket0612
 
Posts: n/a
Default calculating an age


I have 2 cells, A1 were a date will be input and A2 were a date of birth
will be input. I then have cell A3 were I would like it to show the
someone's age next birthday at date in the cell A1. For example:

A1 = 1 May 2005
A2 = 15 June 1950 (date of birth)
A3 = 55

so on 1 May 2005, the age next birthday of the individual is 55.

all help appreciated, thanks


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=375004

  #2   Report Post  
Ragdyer
 
Posts: n/a
Default

You can use the DATEDIF() function.
Except in XL2k, however, that's an undocumented function.

You can find it fully explained on Chip Pearson's web site at:

http://www.cpearson.com/excel/datedif.htm
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"rocket0612" wrote
in message ...

I have 2 cells, A1 were a date will be input and A2 were a date of birth
will be input. I then have cell A3 were I would like it to show the
someone's age next birthday at date in the cell A1. For example:

A1 = 1 May 2005
A2 = 15 June 1950 (date of birth)
A3 = 55

so on 1 May 2005, the age next birthday of the individual is 55.

all help appreciated, thanks


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile:

http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=375004


  #3   Report Post  
mangesh_yadav
 
Posts: n/a
Default


=ROUNDUP(YEARFRAC(B1,A1),0)

You need to enable the Analysis ToolPak to use this function. To do
this, Tools Addins. Check the box Analysis ToolPak

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375004

  #4   Report Post  
rocket0612
 
Posts: n/a
Default


Thanks, I found a way using dateif from
http://www.cpearson.com/excel/datedif.htm#Age, but your way is much
easier, thanks alot :)


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=375004

  #5   Report Post  
mangesh_yadav
 
Posts: n/a
Default


Thanks for the feedback. I have seen the link you mentioned.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375004



  #6   Report Post  
Mangesh Yadav
 
Posts: n/a
Default

Hi Ragdyer (Also to Chip Pearson),

I was going through the link you mentioned, and saw the age calculation
formula. It is not fool-proof. It fails at the following case:

31-Jan-2000 1-Mar-2005 5 1 -2


It shows the days as -2

Mangesh



"Ragdyer" wrote in message
...
You can use the DATEDIF() function.
Except in XL2k, however, that's an undocumented function.

You can find it fully explained on Chip Pearson's web site at:

http://www.cpearson.com/excel/datedif.htm
--
HTH,

RD

--------------------------------------------------------------------------

-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------

-


"rocket0612"

wrote
in message ...

I have 2 cells, A1 were a date will be input and A2 were a date of birth
will be input. I then have cell A3 were I would like it to show the
someone's age next birthday at date in the cell A1. For example:

A1 = 1 May 2005
A2 = 15 June 1950 (date of birth)
A3 = 55

so on 1 May 2005, the age next birthday of the individual is 55.

all help appreciated, thanks


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile:

http://www.excelforum.com/member.php...o&userid=19492
View this thread:

http://www.excelforum.com/showthread...hreadid=375004




  #7   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Mon, 30 May 2005 03:48:01 -0500, rocket0612
wrote:


I have 2 cells, A1 were a date will be input and A2 were a date of birth
will be input. I then have cell A3 were I would like it to show the
someone's age next birthday at date in the cell A1. For example:

A1 = 1 May 2005
A2 = 15 June 1950 (date of birth)
A3 = 55

so on 1 May 2005, the age next birthday of the individual is 55.

all help appreciated, thanks


=YEAR(DATE(YEAR(A1)+(A1DATE(YEAR(A1),MONTH(
A2),DAY(A2))),MONTH(A2),DAY(A2)))-YEAR(A2)


--ron
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
not calculating formulas doros Excel Discussion (Misc queries) 4 April 5th 05 12:29 PM
Calculating Working Days will Excel Worksheet Functions 5 March 22nd 05 01:44 PM
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD Excel Worksheet Functions 1 March 15th 05 06:49 PM
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! RICHARD Excel Discussion (Misc queries) 0 March 1st 05 02:53 PM
Calculating Percentages with Variables tssjhs Excel Worksheet Functions 1 January 28th 05 02:27 AM


All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"