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.