formulas

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

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

"Michelle" wrote in message ...
What formula do you use to change a birthdate to find the
age of person

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 he

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

Dan E

"Dan E" wrote in message ...
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

"Michelle" wrote in message ...
What formula do you use to change a birthdate to find the
age of person

"Dan E" wrote in message
...
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 he

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

Dan E

"Dan E" wrote in message
...
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

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


--
James V. Silverton
Potomac, Maryland, USA

"James Silverton" wrote in message
...

"Dan E" wrote in message
...
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 he

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

Dan E

"Dan E" wrote in message
...
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

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


--
James V. Silverton
Potomac, Maryland, USA


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).


--
James V. Silverton
Potomac, Maryland, USA




--
James V. Silverton
Potomac, Maryland, USA