Summarizing bi-weekly data into years

[michaeljc70]

I have data I exported that has expenses on a bi-weekly basis. It contains 3 years+current year. It looks like this (condensed):

	1/1/2016- 1/15/2016 <tbody> </tbody>	.....	8/16/2019- 8/31/2019	9/1/2019- 9/15/2019	9/16/2019- 9/25/2019
Expense 1	500		300	600	700
Expense 2	200		250	225	275

<tbody>
</tbody>

Expected Results

	2017	2018	2019
Expense 1	xxx	yyy	zzz
Expense 2	aaa	bbb	ccc

<tbody>
</tbody>

Note that 2017 would be 9/26/2016-9/25/2017.
What I need is a summary of expenses for the last 3 years. 9/26/2018-9/25/2019, 9/26/2017-9/25/2018 and 9/26/2016-9/25/2017.

I can think of a few ways to do this in a roundabout way, but I am looking for the easiest/most direct. I would probably add a row of formulas that gives each column a year (if it will be used) and then pivot it. Is this the best approach? I will be redoing this frequently with new data so the end date can change but there will always be 3+ years of bi-weekly data.

 

[mrshl9898]

I added 2 rows.

Row 1 = your dates
B2 =YEAR(DATEVALUE(LEFT(B1,FIND("-",B1)-1)))
B3 =YEAR(DATEVALUE(TRIM(MID(B1,FIND("-",B1)+1,11))))

B12 = 2017, C12 = 2018
A13 = Expense 1
B13 = =SUMIFS(4:4,$2:$2,B$12,$3:$3,B$12)


That SUMS the year if the start and end date are in the year, so may need to be modified