Age

[Roy Gudgeon]

HiGuys

I need to be able to report the age of someone at a given point in the future.
I know how to use the year(today) formula which works great for age at
today's date but need to enter a future date, compare this to the date of
birth and report the age that a person will be on the date in the future that
I have entered.

 

[David Biddulph]

I wouldn't recommend using YEAR(today()), unless you make the formula more
complicated.
If DoB is between now and the end of the year, =YEAR(TODAY()-YEAR(DoB) will
give the age you will be on your birthday, not the age you are now.

Try =DATEDIF(DoB,Future_Date,"y")
More info at http://www.cpearson.com/excel/datedif.aspx

 

[Jacob Skaria]

With DOB in cell A1 and future date in cell B1 try the below...

=DATEDIF(A1,B1,"y")

'OR

=DATEDIF(A1,B1,"y")&" years "&
DATEDIF(A1,B1,"ym")&" months "&
DATEDIF(A1,B1,"md")&" days"

If this post helps click Yes

 

[Roy Gudgeon]

Hi Jacob

about a minute after I posted the question I found a similar question with
an embedded link that pointed me to this formula and I got it too work.
My list of functions (EXcel2007) did not list this function but when I
wrote the syntax it still worked.

really appreciate you replying so promptly

thanks
Roy

 

[Gord Dibben]

The only version of Excel to document DATEDIF was 2000.


Gord Dibben MS Excel MVP

 

[David Biddulph]

Hence we usually point readers to http://www.cpearson.com/excel/datedif.aspx