| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate # days from today in a Pivot Table
I have a date in my pivot table data and I'd like to calculate in a field an
'aging' number of days since today. So, for example, my item has a date of 3/1/09 and today is 3/29/09, I'd like to calculate to 28. This, of course would change every day the pivot is refreshed. I've tried using NOW type functions in my pivot table field calculation, but no luck. Any suggestions? Thanks, O Orrin Wolf |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate # of days to the future from TODAY | Excel Discussion (Misc queries) | |||
| Count Days more than 180 days prior to today | Excel Worksheet Functions | |||
| Pivot Table - only show dates greater than =today() | Excel Discussion (Misc queries) | |||
| CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY | Excel Worksheet Functions | |||
| how to calculate a date .. say 34 days from today | Excel Discussion (Misc queries) | |||
Threaded Mode
