[已解决]求助高手

fhs1010

日期	周龄
2015-11-1	1W-2
2015-11-2	1W-3
2015-11-3	1W-4
2015-11-4	1W-5
2015-11-5	1W-6
2015-11-6	1W-7
2015-11-7	2W-1
2015-11-8	2W-2
2015-11-9	2W-3
2015-11-10	2W-4
2015-11-11	2W-5	注:怎么才能把日期(2015-11-1)后面相对应的为1W-1
2015-11-12	2W-6
2015-11-13	2W-7
2015-11-14	3W-1
2015-11-15	3W-2
2015-11-16	3W-3
2015-11-17	3W-4
2015-11-18	3W-5
2015-11-19	3W-6
2015-11-20	3W-7
2015-11-21	4W-1
2015-11-22	4W-2
2015-11-23	4W-3
2015-11-24	4W-4
2015-11-25	4W-5
2015-11-26	4W-6
2015-11-27	4W-7
2015-11-28	5W-1
2015-11-29	5W-2
2015-11-30	5W-3
2015-12-1	5W-4
2015-12-2	5W-5
2015-12-3	5W-6
2015-12-4	5W-7
2015-12-5	6W-1
2015-12-6	6W-2
2015-12-7	6W-3
2015-12-8	6W-4
2015-12-9	6W-5

最佳答案

月排行榜 / 总排行榜

baksy

2015-11-2 19:39

附件

跳转到最佳答案楼层

baksy

附件

baksy

追加

tjshenjian

=TEXT(BASE(ROW(A7),7)+1,"0W-0")

grf1973

B2=TEXT(INT((A2-$A$2)/7)+1&WEEKDAY(A2,1),"0W-0")

grf1973

.........