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.
--
thanks
Roy

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
--
David Biddulph

"Roy Gudgeon" wrote in message
...
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.
--
thanks
Roy

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
---------------
Jacob Skaria


"Roy Gudgeon" wrote:

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.
--
thanks
Roy

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


--
thanks
Roy


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Roy Gudgeon" wrote:

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.
--
thanks
Roy

The only version of Excel to document DATEDIF was 2000.


Gord Dibben MS Excel MVP

On Mon, 2 Nov 2009 02:56:02 -0800, Roy Gudgeon
wrote:

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

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

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
The only version of Excel to document DATEDIF was 2000.


Gord Dibben MS Excel MVP

On Mon, 2 Nov 2009 02:56:02 -0800, Roy Gudgeon
wrote:

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