create calculated field for age in pivot tables

[pderbie]

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.

 

[Roger Govier]

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)

 

[Eva]

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

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

Greatly appreciated

Eva

 

[Herbert Seidenberg]

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.rackspacecloud.com/03_03_10a.xlsm

 

[Roger Govier]

Very nice solution, Herbert!