本帖最后由 stone1969 于 2014-10-12 20:21 编辑
第一题 方法1 =IF(ABS(-WEEKDAY(B4,2))>ABS(-WEEKDAY(B4)+8),B4-WEEKDAY(B4)+8,B4-WEEKDAY(B4,2))
方法2 =B4-MOD(WEEKDAY(B4+3,2),7)+3
第二题 =TEXT(DATE(B14,1,C14*7)-(13-ROW(A5)),"M/D")
=TEXT((B14&"-1-1")-WEEKDAY((B14&"-1-1"),2)+(C14-1)*7+{1;2;3;4;5;6;7},"m/d")
第三题 方法 =COUNT(1/(WEEKDAY(MONTH(NOW())&-ROW(1:31),2)=6)) 三键合一
方法2 =4+COUNT(IF(MOD(TEXT(NOW(),"e-m")&-{29,30,31},7)=0,))
第四题 =MONTH(IF(B25<DATE(YEAR(B25),MONTH(B25),25),B25,DATE(YEAR(B25),MONTH(B25)+1,DAY(B25))))
第五题 =MONTH(B33&-1)
="第"&NUMBERSTRING(INT((MONTH(B33&-1)+2)/3),1)&"季度"
|