date (autofill) | name | work hour | pieces (number) | note |
07/09/2020 | K | 10 | 256 | day |
07/09/2020 | G | 11 | 349 | night |
08/09/2020 | H | 9 | 201 | day |
08/09/2020 | G | 11 | 367 | night |
09/09/2020 | K | 10 | 257 | day |
09/09/2020 | H | 10 | 244 | day |
and still on.....
now I want formula which is shown weekly report (updating every day so I can see his last 7 days progress) in below table.
name | 01/09 | 02/09 | 03/09 | 04/09 | 05/09 | 06/09 | 07/09 | Avg. |
---|---|---|---|---|---|---|---|---|
K | 239 | 245 | 0 | 0 | 255 | 200 | 256 | 239 |
H | 259 | 256 | 0 | 356 | 345 | 300 | 0 | 303 |
G | 257 | 255 | 0 | 0 | 245 | 255 | 349 | 272 |
and also operator do night and day both shifts also same day both pieces lots total also should shown in above table. I require date formula in above table which should changes daily. for example next day in heading, 02/09 to 08/09 date must show.