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.
|