| 楼主 罗刚君 |
Q:如何计算本季度天数总和？ A:公式较多，一并罗列 公式长度 公式 55 =SUM(DAY(EOMONTH(NOW(),{0,1,2}-MOD(MONTH(NOW())-1,3)))) 55 =SUM(DAY(EOMONTH(NOW(),{0,1,2}-MOD(MONTH(NOW())+2,3)))) 54 =SUM(EOMONTH(NOW(),MOD(-MONTH(NOW()),3)-{3,0})*{-1,1}) 53 =SUM(EDATE(CEILING(MONTH(NOW()),3)&-1,{-2,1})*{-1,1}) 65 =90+CHOOSE(MONTH(NOW())/3.1+1,DAY(DATE(YEAR(NOW()),3,))=29,1,2,2) 64 =90+CHOOSE(CEILING(MONTH(NOW())/3,1),MOD(YEAR(NOW()),4)=0,1,2,2) 64 =90+MAX(DAY(DATE(YEAR(NOW()),3,))-28,INT(MONTH(NOW())^0.53-0.8)) 64 =91+IF(MONTH(NOW())>6,1)-(MONTH(NOW())<4)*(MOD(YEAR(NOW()),4)>0) 64 =IF(MONTH(NOW())>6,92,91)-(MOD(NOW(),1461)>366)*(MONTH(NOW())<4) 63 =SUM(DATE(YEAR(NOW()),CEILING(MONTH(NOW()),3)+{1,-2},0)*{1,-1}) 63 =90+CHOOSE(ROUNDUP(MONTH(NOW())/3,),MOD(YEAR(NOW()),4)=0,1,2,2) 63 =90+CHOOSE(MONTH(NOW())^0.6,DAY(DATE(YEAR(NOW()),3,))=29,1,2,2) 63 =CHOOSE((MONTH(NOW())+2)/3,DAY((YEAR(NOW())&-3)-1)+62,91,92,92) 63 =9&MAX(LOOKUP(MONTH(NOW())-0.1,{0,3,6})/3,MOD(YEAR(NOW()),4)=0) 63 =9&MAX((LOOKUP(MONTH(NOW()),{1,4,7})-1)/3,MOD(YEAR(NOW()),4)=0) 63 =SUM(DATE(YEAR(NOW()),CEILING(MONTH(NOW()),3)+{1,-2},0)*{1,-1}) 62 =92-MIN((DAY(DATE(YEAR(NOW()),2,29))=1)+1,INT(6/MONTH(NOW()))) 62 =SUM(DATE(YEAR(NOW()),INT(MONTH(NOW())/3.1)*3+{1,4},1)*{-1,1}) 62 =SUM(DAY(DATE(YEAR(NOW()),CEILING(MONTH(NOW()),3)+{-1,0,1},))) 62 =9&MAX(DAY(DATE(YEAR(NOW()),3,))-28,INT(MONTH(NOW())^53%-0.8)) 62 =CHOOSE(MONTH(NOW())/3+0.9,90+(MOD(YEAR(NOW()),4)=0),91,92,92) 62 =9&MID(1*(MOD(YEAR(NOW()),4)=0)&122,INT((MONTH(NOW())+2)/3),1) 62 =SUM(DATE(YEAR(NOW()),CEILING(MONTH(NOW()),3)-{2,-1},)*{-1,1}) 62 =92-MIN((DAY(DATE(YEAR(NOW()),2,29))=1)+1,INT(6/MONTH(NOW()))) 62 =CHOOSE(INT((MONTH(NOW())+2)/3),MOD(YEAR(NOW()),4)=0,1,2,2)+90 62 =SUM(DATE(YEAR(NOW()),INT(MONTH(NOW())/3.1)*3+{1,4},1)*{-1,1}) 62 =SUM(DATE(YEAR(NOW()),CEILING(MONTH(NOW()),3)+{-2,1},)*{-1,1}) 61 =SUM(DAY(DATE(YEAR(NOW()),FLOOR(MONTH(NOW())-1,3)+{2,3,4},))) 61 =SUM(DATE(YEAR(NOW()),INT(MONTH(NOW())/3.1)*3+{4,1},)*{1,-1}) 61 =SUM(DAY(DATE(YEAR(NOW()),{2,3,4}+FLOOR(MONTH(NOW())-1,3),))) 61 =92-(MONTH(NOW())<7)-(MOD(YEAR(NOW()),4)<>0)*(MONTH(NOW())<4) 61 =92-SUM((MONTH(TODAY())<{4,7})*(MOD(YEAR(TODAY()),4)>{0,-1})) 61 =SUM(DAY(DATE(YEAR(NOW()),FLOOR(MONTH(NOW())-1,3)+{2,3,4},))) 61 =SUM(DATE(YEAR(NOW()),FLOOR(MONTH(NOW())+5,3)-{5,2},)*{-1,1}) 61 =SUM(DATE(YEAR(NOW()),INT(MONTH(NOW())/3.1)*3+{4,1},)*{1,-1}) 61 =91+IF(MONTH(NOW())<4,-(MOD(YEAR(NOW()),4)>0),MONTH(NOW())>6) 60 =91-MIN(DAY(DATE(YEAR(NOW()),2,29))=1,INT(6/MONTH(NOW()))-1) 60 =91+(MONTH(NOW())>6)-(MOD(YEAR(NOW()),4)>0)*(MONTH(NOW())<4) 60 =91+(MONTH(NOW())>6)-(MONTH(NOW())<4)*(MOD(YEAR(NOW()),4)>0) 60 =92-(MONTH(NOW())<7)-(MONTH(NOW())<4)*(MOD(YEAR(NOW()),4)>0) 59 =91-MIN(DAY(DATE(YEAR(NOW()),3,))=28,INT(6/MONTH(NOW()))-1) 59 =9&MAX(MOD(YEAR(NOW()),4)=0,MIN(INT(MONTH(NOW())/3-0.1),2)) 59 =91-MIN(DAY(DATE(YEAR(NOW()),3,))=28,INT(6/MONTH(NOW()))-1) 59 =9&IF(MONTH(NOW())>=7,2,IF(DAY((YEAR(NOW())&-3)-1)=28,0,1)) 58 =9&CHOOSE((MONTH(NOW())/3+0.7),MOD(YEAR(NOW()),4)=0,1,2,2) 58 =9&MAX(MOD(YEAR(NOW()),4)=0,MIN(INT(MONTH(NOW())/3-1%),2)) 57 =90+CHOOSE(MONTH(NOW())/3+3/4,MOD(YEAR(NOW()),4)=0,1,2,2) 57 =DAY(DATE(YEAR(NOW()),CEILING(MONTH(NOW()),3)+1,1)-90)+89 57 =90+CHOOSE(MONTH(NOW())/3.1+1,MOD(YEAR(NOW()),4)=0,1,2,2) 56 =DAY(DATE(YEAR(NOW()),FLOOR(MONTH(NOW())+2,3)+1,)-89)+89 56 =92-MIN(DAY(DATE(YEAR(NOW()),2,30)),INT(6/MONTH(NOW()))) 56 =90+MAX(INT(MONTH(NOW())^0.53-0.8),MOD(YEAR(NOW()),4)=0) 56 =92-MIN(DAY(DATE(YEAR(NOW()),2,30)),INT(6/MONTH(NOW()))) 56 =DAY(DATE(YEAR(NOW()),FLOOR(MONTH(NOW())+2,3)+1,)-89)+89 55 =90+CHOOSE(MONTH(NOW())^0.6,MOD(YEAR(NOW()),4)=0,1,2,2) 54 =SUM(DAY(EOMONTH(NOW(),MOD(-MONTH(NOW()),3)-{2,1,0}))) 53 =COUPDAYS(NOW(),99714,4,1)-(--TEXT(NOW(),"em")<19004) 52 =9&MID(2210+(MOD(NOW(),1461)<92),5-MONTH(NOW())/3,1) 50 =91+(NOW()>"7-1"-1)-ISERR(-"2-29")*(NOW()<"4-1"+0) 49 =92-(NOW()<"7-1"*1)-(NOW()<"4-1"*ISERR("2-29"*1)) 46 =CHOOSE(MONTH(NOW())^0.6,"4-1"-"1-1",91,92,92) 27 =COUPDAYS(NOW(),401769,4,1) 26 =COUPDAYS(NOW(),99714,4,1) 26 =COUPDAYS(NOW(),73051,4,1) 26 =COUPDAYS(NOW(),6^9/9,4,1) |
| 2楼 wenshui2006 |
罗版好强啊,,,,,学习,,,学习,,,, |
| 3楼 paul001 |
方法真多 |