create calculated field for age in pivot tables
 

I need to create a calculated field for Age from the birth date within a
Pivot Table (Excel Office 2007). I can not create age in the data set
because it is pulling directly from a data source.

I tried just using the formula =INT((TODAY()- Birthday)/365.25) but received
an error.

create calculated field for age in pivot tables
 

Hi

That won't work because you cannot use NOW() or TODAY() in PT Calculated
fields or items.

I think the only way you can do it (approximately) if you cannot add a
field to your source data, would be to make a calculated field with the
formula
=2010-Year(Birthday)

--
Regards
Roger Govier

pderbie wrote:
I need to create a calculated field for Age from the birth date within a
Pivot Table (Excel Office 2007). I can not create age in the data set
because it is pulling directly from a data source.

I tried just using the formula =INT((TODAY()- Birthday)/365.25) but received
an error.

create calculated field for age in pivot tables
 

Try this
DATEDIF(birthdate,TODAY(),"y")

--
Please click "yes" if this post helped you!

Greatly appreciated

Eva


"pderbie" wrote:

I need to create a calculated field for Age from the birth date within a
Pivot Table (Excel Office 2007). I can not create age in the data set
because it is pulling directly from a data source.

I tried just using the formula =INT((TODAY()- Birthday)/365.25) but received
an error.

create calculated field for age in pivot tables
 

Excel 2007 PivotTable
As Roger noted, no TODAY() allowed in PT.
A macro work-around can give you a bit
more accuracy:
http://c0718892.cdn.cloudfiles.racks...03_03_10a.xlsm

create calculated field for age in pivot tables
 

Very nice solution, Herbert!
--
Regards
Roger Govier

Herbert Seidenberg wrote:
Excel 2007 PivotTable
As Roger noted, no TODAY() allowed in PT.
A macro work-around can give you a bit
more accuracy:
http://c0718892.cdn.cloudfiles.racks...03_03_10a.xlsm