Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create calculated field for age in pivot tables
Hi
That won't work because you cannot use NOW() or TODAY() in PT Calculated fields or items. I think the only way you can do it (approximately) if you cannot add a field to your source data, would be to make a calculated field with the formula =2010-Year(Birthday) -- Regards Roger Govier 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated field in pivot tables | Excel Discussion (Misc queries) | |||
Pivot tables - Insert Calculated field | Excel Discussion (Misc queries) | |||
Calculated field in Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables - How do I add Functions as a Calculated Field? | Excel Discussion (Misc queries) | |||
calculated field/item in pivot tables | Excel Discussion (Misc queries) |