help needed for VBA question

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

Question:
column1 contains the days of 2011. I want to get the new column2 which converts the days in column1 into Month/week#,.For example, for Feb of 2011, the week1 is from Feb. 1  to Feb. 6 (sunday), week2 is from Feb. 7 (monday) to Feb. 13 (sunday) and so on...

Column1
2/01/2011
2/21/2011
3/01/2011
4/05/2011
.
.
so the column2 I want is
Column2
Feb/Week1
Feb/Week4
Mar/Week1
April/Week2

How to get the Week number? is there anybody can help me? or give me some hints? Thanks a lot!

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：question NEEDED Quest Need Help VBA Help question NEEDED