Warm tip: This article is reproduced from serverfault.com, please click
Advanced date filter in excel
发布于 2020-11-30 09:11:48
I like to ask you for help with my problem in excel :)
My data looks like this:
Basicly event name; start-date; and end-date.
Events can last anything between 1-365 days and I would need to create filter, which would show me all events, which has been active between the choosen period of time.
For example if my filter setting would be: "show me all events, which might be active between 18.1.2020 - 20.1.2020"
Outcome from my dataset should be:
Event2;Event3;Event4
Here is better description of problem in excel. Link to xlsx file
Thank you,
Questioner
Nemmy
Viewed
0
Thank you Harun, unfortunately, I am still on 2016 version of excel, so I cant test it. Anyway is there a way how to return all the values between: Start date and End date? I am thinking maybe some array formula might be able to do it. Something like loop:
X = Start date Do Until X = End date X = X + 1 loopOr other solution :)