Update formula

[Mirelle]

Good morning


Not to sure what you would call what I want done. I have been on Google for awhile, but no luck in finding what I want. Well, I did find you guys.


Your help would be appreciated.

RAW_DATA - WHAT I READ FROM

Date	Amount	Total
2015/05/01	123	1
2015/05/02	124	2
2015/05/03	125	3
2015/05/04	126	4
2015/05/05	127	5
2015/05/06	128	6
2015/05/07	129	7
2015/05/08	130	8
2015/05/09	131	9
2015/05/10	132	10
2015/05/11	133	11

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

RAW_DATA DISPLAY

Date	Faults	No
2015/05/05	127	5
2015/05/06	128	6
2015/05/07	129	7
2015/05/08	130	8
2015/05/09	131	9
2015/05/10	132	10

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

I have daily data (RAW_DATA - WHAT I READ FROM). When I show my information(RAW_DATA DISPLAY)I only want to show the last day plus 5 days past.


So it shows 2015/05/10 to 2015/05/05


Tomorrow a new day will be added to my raw_data, so now I want to show 2015/05/11 to 2015/05/06


So 2015/05/05 will change to 2015/05/06 and the last date will be 2015/05/11. Each date will move one up.


Formula in 2015/05/05 = Sheet1!A6, so now it must change to =Sheet1!A7

Thanx you

Mirelle

 

[Mirelle]

According to my info week 21 is 18 May to 24 May 2015