formulas

[Michelle]

What formula do you use to change a birthdate to find the
age of person

 

[Dan E]

Michelle

If you had the birthday in A1

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

Datedif isn't listed in the function wizard, but can be
found in the help menu.

Dan E

 

[Dan E]

As Mr. McGimpsey just pointed out in response to
another one of my posts...

It's only in the help menu in 2000 (possibly 2003/XP)

For all other XL versions, look here:

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

Dan E

 

[James Silverton]

As Mr. McGimpsey just pointed out in response to
another one of my posts...

It's only in the help menu in 2000 (possibly 2003/XP)

For all other XL versions, look here:

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

Dan E

It's not available in help for my version of Office XP (Excel 2002, I
think). Rather weird is it not?

 

[James Silverton]

It's not available in help for my version of Office XP (Excel 2002, I
think). Rather weird is it not?

OK, I got John Walkenbach's "Excel 2002 Formulas" from the library. It seems
that DATEDIF is actually present (and I find that it actually works) but
Microsoft seems to disown it! I don't think that suggesting the use of a
function whose presence is only because of a glitch or inadvertence is
particularly helpful. How much do you bet that it will be there in the next
reincarnation?

For the record, the format is DATEDIF(start_date, end_date,time_unit_code).
The code is y, m, d, md, ym, yd: all in double quotes for years, months,
days, days ignoring months and years, months ignoring days and years and day
differences ignoring years (whatever use the last three may have). I suspect
that someone thought that DATEDIF was a good idea but she left and the
function lingered on (g).