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