Calulating Age Formula

Need Formula for calulating age from birthdate from current date. I have used
=VALUE((2005)-YEAR(birthdate)), but this gives me the age of year as of end
of 2005. I need formula to calulate age as of today's date or by current
month. I want to show the age in the cell next to the birthdate without
using a date reference from another cell.

Thanks.

Try using: DATEDIF
(no documentation in most Excel versions HELP)
look in here:
http://www.cpearson.com/excel/datedif.htm
Michael Avidan
"Office" - forum manager
http://forums.tapuz.co.il/office

"YUMBUG" wrote:

> Need Formula for calulating age from birthdate from current date. I have used
> =VALUE((2005)-YEAR(birthdate)), but this gives me the age of year as of end
> of 2005. I need formula to calulate age as of today's date or by current
> month. I want to show the age in the cell next to the birthdate without
> using a date reference from another cell.
>
> Thanks.

YUMBUG wrote...
>Need Formula for calulating age from birthdate from current date. I have used
>=VALUE((2005)-YEAR(birthdate)), but this gives me the age of year as of end
>of 2005. I need formula to calulate age as of today's date or by current
>month. I want to show the age in the cell next to the birthdate without
>using a date reference from another cell.

=YEAR(TODAY()-birthdate)-YEAR(0)

would be one way using only documented function calls. Using the
usually undocumented DATEDIF requires something like

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

Thank you.

"Harlan Grove" wrote:

> YUMBUG wrote...
> >Need Formula for calulating age from birthdate from current date. I have used
> >=VALUE((2005)-YEAR(birthdate)), but this gives me the age of year as of end
> >of 2005. I need formula to calulate age as of today's date or by current
> >month. I want to show the age in the cell next to the birthdate without
> >using a date reference from another cell.
>
> =YEAR(TODAY()-birthdate)-YEAR(0)
>
> would be one way using only documented function calls. Using the
> usually undocumented DATEDIF requires something like
>
> =DATEDIF(birthdate,TODAY(),"Y")
>
>