I have a table of events (Columns = Event_ID, Event_Date, Event_Occurance) where I need to report an aggregate over a period of 9 months. For example, I need to report on 11/2021 - 7/2022. My matrix should only show the data in November and accumulate through 7/2022. Then once the date rolls to 8/2022, the data should only show from this date through 4/2023. Any functions/date tables that will help me do this automatically? TIA.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Date table - future dates
- Thread starter boehnc
- Start date
