dates and ages

[mp]

I have a list of names and birthdates in the format:

Diane 5-2-00
Joey 2-9-01
Nancy 12-16-99

I would like to add a third column that calculates the
ages of the persons listed based on todays date (in days).

Does anyone have any idea how to do this?

Thanks!

mp

 

[BrianB]

=TODAY()-B1
format as a number

 

[Gord Dibben]

mp

Check out The DATEDIF Function.

Info at Chip Pearson's site.

http://www.cpearson.com/excel/datedif.htm

Gord Dibben Excel MVP

 

[Soo Cheon Jheong]

Hi,

=DATEDIF(B1,TODAY(),"Y")

--
Regards,
Soo Cheon Jheong
Seoul, Korea
_ _
^¢¯^
--