TruffleOil
New Member
- Joined
- Sep 9, 2022
- Messages
- 18
- Office Version
- 2016
- Platform
- Windows
Hi everyone
I have a set of data with different notification dates for several projects (some different projects have the same notification date).
My goal: filter and list all the projects that fall within a certain date range, in this case by month and year. In this example, I want to show the list of all the projects with notification date in November(more or equal to 1stNov and less or equal 30Nov) (even if they have the same date), whenever I change the calendar month or year to that date. If I change it to April 2023, it should show Project C or more if available.
I saw a video that showed the Filter formula which works fine for this, but I have Excel 2016 and it's not available. I tried Index Match but I'm still a newbie and struggling to come up with a formula. Would appreciate if anyone could help with the right formula for this!!
I have a set of data with different notification dates for several projects (some different projects have the same notification date).
My goal: filter and list all the projects that fall within a certain date range, in this case by month and year. In this example, I want to show the list of all the projects with notification date in November(more or equal to 1stNov and less or equal 30Nov) (even if they have the same date), whenever I change the calendar month or year to that date. If I change it to April 2023, it should show Project C or more if available.
I saw a video that showed the Filter formula which works fine for this, but I have Excel 2016 and it's not available. I tried Index Match but I'm still a newbie and struggling to come up with a formula. Would appreciate if anyone could help with the right formula for this!!