Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I find age in years from anniversary date (Age funtion)?

I need to calculate age given birth-date.

First, I tried
=YEAR(NOW())-YEAR(cell ref with birthday)

This works, but (of course) the resulting year rolls-over on January 1, not
on the actual birthday.

I searched for "Age function" but (aside from Access) the closest I could
find was:

"How to calculate ages before 1/1/1900 in Excel" (Q245104)

http://support.microsoft.com/kb/245104/en-us

Well, I am not dealing with dates before 1900, but I tried it anyway (even
though I could not believe I needed a VB script to do this)

I created the VB script "AgeFunc" and then adapted the formula

=AgeFunc(startdate,enddate)

to

=AgeFunc(YEAR(NOW()),YEAR(AE353))

Where AE353 is the cell reference with the birth-date.

However, this returned the error #VALUE!

This is such a basic function ... one of the first "functions" that toddlers
understand ... how come I can't do this in Excel?!?

Surely there is a built-in "AgeFunc" in Excel ... can anyone help?!?

Thanks in advance

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default How do I find age in years from anniversary date (Age funtion)?

=DATEDIF(start_date,end_date,"y")
http://www.cpearson.com/excel/datedif.aspx
--
David Biddulph

"Enquire" wrote in message
...
I need to calculate age given birth-date.

First, I tried
=YEAR(NOW())-YEAR(cell ref with birthday)

This works, but (of course) the resulting year rolls-over on January 1,
not
on the actual birthday.

I searched for "Age function" but (aside from Access) the closest I could
find was:

"How to calculate ages before 1/1/1900 in Excel" (Q245104)

http://support.microsoft.com/kb/245104/en-us

Well, I am not dealing with dates before 1900, but I tried it anyway (even
though I could not believe I needed a VB script to do this)

I created the VB script "AgeFunc" and then adapted the formula

=AgeFunc(startdate,enddate)

to

=AgeFunc(YEAR(NOW()),YEAR(AE353))

Where AE353 is the cell reference with the birth-date.

However, this returned the error #VALUE!

This is such a basic function ... one of the first "functions" that
toddlers
understand ... how come I can't do this in Excel?!?

Surely there is a built-in "AgeFunc" in Excel ... can anyone help?!?

Thanks in advance



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
Date range selection? Anniversary dates mrburnette Excel Worksheet Functions 6 August 30th 07 07:16 PM
Anniversary of a date Becks Excel Discussion (Misc queries) 4 August 23rd 07 02:38 PM
formula to display anniversary date sharita Excel Worksheet Functions 3 February 13th 07 12:57 AM
calculate anniversary of date after specified date slymeat Excel Worksheet Functions 3 July 5th 05 01:53 AM
How do I get an anniversary date? Steve j. Excel Worksheet Functions 1 November 18th 04 05:10 PM


All times are GMT +1. The time now is 10:10 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"