Dear all,
I need your help to find sales based on the store opening date. See below:



See image 1

I need to find the comparable sales for YTD and MTD based on the opening date:
Since store 123 opened in 2015 – This is easy, the comparable sales in 2018 are from the beginning of the year
Store 124 & 125 opened during 2017 and for that reason the comparable YTD sales should start to sum only after Comp date (COLUMN E).
Is there a formula that I can use to get that?

See image 2

Thanks very much for your help.

Attached Images

	image 1.png (34.9 KB, 40 views)
	image 2.png (4.6 KB, 39 views)