Referencing a chosen date in Index/Match function
Hello,
I am looking to reference a date of my choosing from my sheet summary (shown below)
(want to be able to edit the date value to filter the data based on certain weeks) in my Index/Match function, I have it set up currently so that it works using the "current week" but I would like to adjust this so that myself or another user can adjust the week in this sheet without having to change it in the other sheets.
Here is the current function:
This function pulls from the "current week" as shown in screenshot below, I would like to instead use the "week ending date" from my sheet summary to select a week from this list below as the row to pull the data from, is this possible? Thank you for the help!
Answers
-
Which reference is looking at the dates?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 73 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!