I have a pivot table that i need to only show items that have a due date that are greater than 30 days old. I would like this to update daily so that i am not required to go in and change the filter date each time. Is there a way to use the TODAY function in the filters or reference a cell for the date to filter by? Any guidance will be greatly appreciated.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!