View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pderbie pderbie is offline
external usenet poster
 
Posts: 1
Default 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.