Calculate events during a certain period

My idea was that the column date week has the seven days of week, letīs say this week 2-6-2014 to 8-6-2014,
next week 9-6-2014 to 15-6-2014.
Using the formula TODAY() I can define which is the specific week, and insert the information from the table below,
Like copy paste information according the data on the present week,

(this table is constantly changing)

Events type	Number of events
A	5
B	10

On the following week I need to hold those values in week 1 (2-6-2014 to 8-6-2014), and insert the new ones to other row (9-6-2014 to 15-6-2014)

Events type	Number of events
A	10
B	8

The objective is that the end result is like this:

date week	Event A	Event B
2-8-2014 / 8-6-2014	5	10
9-6-2014 / 15-6-2014	10	8

Is it possible?