Need help extracting # of stores open BEFORE a date, and opened WITHIN a date... super confused.

[excelNONgenius]

Hello,

I'm having problems with this, but I think the biggest reason is that I've been overthinking this too much.
I have the following columns. For this problem I only need ACTIVESTORE, LOCATION ACTIVE DATE, and LOCATION INACTIVE DATE.

From the dataset above, I need to extract the state on A.

Then on column B "the number [i.e. 1, 4, 19, etc] of stores already active by the start of 2018"

Then on column C I need to get a number that tells me HOW MANY STORES were active ONLY DURING 2018.

The difference between B and C is that B is a number that was active before 2018. Column C is only a number if the ACTIVE status occurred during 2018.

What do you think?

 

[Skyybot]

Are the results going to another sheet separate from the data?

 

[excelNONgenius]

Are the results going to another sheet separate from the data?

Yes, sorry, data is on sheet1, the results would go into sheet2.

 

[Skyybot]

Are sheet names Sheet1 and Sheet2?

 

[excelNONgenius]

Are sheet names Sheet1 and Sheet2?

That's right

 

[Skyybot]

Are you looking for a VBA solution or formula solution?

 

[excelNONgenius]

Are you looking for a VBA solution or formula solution?

Formula, ideally