Calculated field in Pivot table using min of date
I have a pivot table that returns the min of a date per category . Can I have a calculated field that works like this: date - Today
I tried a calculated field but couldn't select the min of date to then minus () Today....
Solution
Pivot tables can't use a formula such as Today() in their calculated fields. So what I would recommend is adding a column in your table that has today() for the rows, then you can use that column to subtract from instead of the today() function, which should workaround this excel constraint.
- Excel VBA function to print an array to the workbook
- How do I copy/paste Interior Colors only in Excel?
- Any way to get the real last row not affected by autofilter? Without altering current autofilter status, using UsedRange nor looping cells from bottom
- Using tables and column titles in VLOOKUP
- Auto align data of an Excel table
- Office VSTO Add-ins vs Office Add-ins using Office JS API
- Excel macro to highlight all cells that match value in current cell
- How do I apply conditional formatting in vba?
- Can you display a SQL Server Image datatype column in Excel?
- Excel: macro to export worksheet as CSV file without leaving my current Excel sheet
- Workbook.UpdateFromFile stops runtime
- Merging annotation with differential expression output
- Append to Text File VBA
- Can I check if cells are a Date and change their format?
- Application.OnTime Delays When There Is No User Interaction (Even if Excel Is Active)
- Using Excel VBA (Name statement) to change file extension from .txt to .csv, getting Run-time error '75': Path/File access error
- How to AutoFill using data in every third row?
- Why does Add-Content translates the comma separator from .TotalSeconds into a dot separator?
- How to change the case of a character in a specific expression, using regex?
- Count days within a date range that fall into selected months (via checkboxes)
- Put a user form directly on the excel sheet
- Changing chart types with vba
- How do I find min value of a range
- Return URL From First Search Result
- Change a macro to use late bindings
- How to push data from excel to SQL Server?
- Excel's fullname property with OneDrive
- Using Excel while macros are running
- How to find cells that contain images with openpyxl
- Excel dynamic linest