Thread: create calculated field for age in pivot tables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_8_] Roger Govier[_8_] is offline
external usenet poster
  
Posts: 376
Default create calculated field for age in pivot tables
Very nice solution, Herbert!
--
Regards
Roger Govier

Herbert Seidenberg wrote:
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