I have an Excel spreadsheet with a list of dates and items. I'm working on a formula that will provide a list of items that match the current date. It works if I have an exact match (ex. 2/4/2023) but I'm trying to get the formula to list items that have a similar month and day (ex. 2/4/2021, 2/4/2023).
Here's the formula but I can't figure out how to change the search to find multiple entries.
=FILTER(A2:A30,B2:B30=C1)
Any suggestions would be appreciated. Best regards
- Maurice
if an exact match with day and month
=FILTER(B2:B33,(MONTH(A2:A33)=MONTH(C1))*(DAY(A2:A33)=DAY(C1)))
see Column I
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
How aboutFormula:
Please Login or Register to view this content.
It works perfectly! Thank you!
you are welcome
Not sure who you're talking to, but glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks