Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 4

Age based on birthdate

I am using Excel 2007 and seems the DATEDIF function is no longer available.
What is the formula to calculate ones age based upon a birthdate.

The following formula does not seem to work (if today is 11/14/2008 and
birthdate is 11/13/1958, it results in 55, instead of 54):

=YEAR(Today()) - YEAR(A2)

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Calculate a date based on birthdate and future age	AMcShea	Excel Discussion (Misc queries)	4	January 7th 09 07:49 PM
Calculate age based on birthdate & end date	Rachelle W.	Excel Discussion (Misc queries)	7	June 29th 07 03:58 PM
Age from birthdate	Nev	Excel Worksheet Functions	9	November 19th 06 05:51 PM
How can I compute a kids age based on his birthdate	Coach T	Excel Worksheet Functions	5	July 4th 05 04:01 PM
how to get age using birthdate	tyniyvonne	Excel Discussion (Misc queries)	3	December 6th 04 06:09 PM

All times are GMT +1. The time now is 09:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us