sparkytech
Board Regular
- Joined
- Mar 6, 2018
- Messages
- 96
- Office Version
- 365
- 2019
I have column "W" with text comments that also contain dates. For example: "abc ~ 06.01.22 ~ This is a sample comment!"
I need help creating a filter to look at column "W", and only show rows that contain the current month / year in this string of text in cell "W'. My thought is that it could look for the string: {current month number}.**.{current year}. I hope that makes sense... is this possible?
I need help creating a filter to look at column "W", and only show rows that contain the current month / year in this string of text in cell "W'. My thought is that it could look for the string: {current month number}.**.{current year}. I hope that makes sense... is this possible?