We have three kinds of stores , open , closed and owner changed. We have data from 1992 till 2017. In first two sheets we need to show all the open stores till the current month and year. We have used interval match function for that
In rest of the sheets we need data of only the current year and month selected (stores opened or closed in current month/year) . If we use the same filter used in other sheets , we are getting the count of all open stores from 92, how to limit it only to current year and month ?
Should i create another year / month filter or is there any ways in which i can control the data in sheets?