B09:o豆苗
第一题- =CHOOSE(COLUMN(),TEXT(ODD(40909+465*RAND()),"yyyy-mm-dd"),LOOKUP(EVEN(MOD(RANDBETWEEN(1,40909)-2,7)),{0,2,4,6},{"星期一","星期三","星期五","星期日"}))
复制代码 第二题- =MID("甲乙丙丁戊己庚辛壬癸",MOD(TEXT(A13,"[$-130000]e")-4,10)+1,1)&MID("子丑寅卯辰巳午未申酉戌亥",MOD(TEXT(A13,"[$-130000]e")-4,12)+1,1)&"年"&" "&TEXT(TEXT(A13,"[$-130000]M-D"),"[DBNum1]M月D日")
复制代码 第三题- =IF(ROW()=27,TEXT(COLUMN(A1),"[DBNum1]"),IF(((7*ROW(A1)-20+COLUMN(A1))<0)+(MOD(7*ROW(A1)-20+COLUMN(A1),3)=0)+((7*ROW(A1)-20+COLUMN(A1))>30),"",7*ROW(A1)-20+COLUMN(A1)))
复制代码 |