Hi,
I would like to use a date filter on my pivottable that shows only the next 12 months of data. Unfortunaltely the build-in functionality in Excel doesn't seem to include this option. The date filter 'after' is not an option as would have to update the date manually.
I would like to base the formula on the current month and not the current day - meaning that the filter should show TRUE for dates within the next 12 months including the current month.
Is that possible?
I would like to use a date filter on my pivottable that shows only the next 12 months of data. Unfortunaltely the build-in functionality in Excel doesn't seem to include this option. The date filter 'after' is not an option as would have to update the date manually.
I would like to base the formula on the current month and not the current day - meaning that the filter should show TRUE for dates within the next 12 months including the current month.
Is that possible?