Snasui Excel Forum

ผมต้องการให้แสดง Week1,2,3....
วันที่ 1 - 7 ในอาทิตย์นั้นๆ ตามตัวอย่างครับ
01/01/2021 week1
02/01/2021 week1
03/01/2021 week1
04/01/2021 week1
05/01/2021 week1
06/01/2021 week1
07/01/2021 week1
08/01/2021 week2
09/01/2021 week2
10/01/2021 week2
11/01/2021 week2
12/01/2021 week2
13/01/2021 week2
14/01/2021 week2

.....

ตัวอย่างสูตร

B2

="week"&INT(ROW(7:7)/7)

Norkaz