create calculated field for age in pivot tables

  • Thread starter Thread starter pderbie
  • Start date Start date
P

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.
 
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)
 
Try this
DATEDIF(birthdate,TODAY(),"y")

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

Greatly appreciated

Eva
 
Back
Top