Birthday

[Keith]

I am sorry I seem dense on this!
Here is what I have;
Column B I have 6/9/70 and in column C I want it to
calculate the age of the person from todays date without
having to enter todays date everytime I open the
worksheet. For example I want it to show me that this
person is 34 until the person actually turns another year
older next on their birthday. So if you could please
type exactly what I am suppose to put in for the formula
I would appreciate it.

Thanks, Keith

 

[chasH]

This formula will (or should) work :-

=INT((TODAY()-B2)/365)

Where cell B2 contains the persons birthdate.

The functiopn TODAY() will calculate from today's date,
and you need the divide by 365 to change it to years, and
then the INT(eger) value to ignore the decimal bits of a
year.

 

[Don Guillett]

try
=DATEDIF(b2,TODAY(),"Y")

 

[Andy B]

Hi

Try this:
=TEXT(TODAY()-B1+1,"YY")

 

[Peo Sjoblom]

Please stay in the original thread, you have an answer there

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)