Thread: create calculated field for age in pivot tables
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default create calculated field for age in pivot tables
Excel 2007 PivotTable
As Roger noted, no TODAY() allowed in PT.
A macro work-around can give you a bit
more accuracy:
http://c0718892.cdn.cloudfiles.racks...03_03_10a.xlsm
Reply With QuoteReply With Quote