1. I would like to add a Text Box that will load with today’s date, I believe that should be simple enough through the initialize sub. 2. I would like to click on the commandbutton for a date and it will fill i
如: =WEEKNUM(A1)=WEEKNUM(TODAY()或者:日期在a1=INT(A1-DATE(YEAR(A1),1,0)+WEEKDAY(DATE(YEAR(A1),1,0),1)+7-WEEKDAY(A1,1)/7)也可以用VBA:under the iso standard, a week always begins on a monday, and ends on a sunday.the first week of a year is that week which contains the...