Age

  • Thread starter Thread starter Roy Gudgeon
  • Start date Start date
R

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.
 
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
 
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
 
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
 
The only version of Excel to document DATEDIF was 2000.


Gord Dibben MS Excel MVP
 
Back
Top