老師改一下,謝謝10

作者：文華財經(jīng) 來源：cxh99.com 發(fā)布時間：2018年07月17日

咨詢內(nèi)容： ?DATE17011:=IF(YEAR==2017 AND MONTH==1 AND (DAY==19 OR DAY==0 OR DAY==0),1,0);DATE17021:=IF(YEAR==2017 AND MONTH==2 AND (DAY==6 OR DAY==21 OR DAY==0),1,0);DATE17031:=IF(YEAR==2017 AND MONTH==3 AND (DAY==3 OR DAY==10 OR DAY==0),1,0);DATE17041:=IF(YEAR==2017 AND MONTH==4 AND (DAY==5 OR DAY==19 OR DAY==25),1,0);DATE17051:=IF(YEAR==2017 AND MONTH==5 AND (DAY==9 OR DAY==0 OR DAY==0),1,0);DATE17061:=IF(YEAR==2017 AND MONTH==6 AND (DAY==2 OR DAY==29 OR DAY==0),1,0);DATE17071:=IF(YEAR==2017 AND MONTH==7 AND (DAY==24 OR DAY==0 OR DAY==0),1,0);DATE17081:=IF(YEAR==2017 AND MONTH==8 AND (DAY==14 OR DAY==21 OR DAY==0),1,0);DATE17091:=IF(YEAR==2017 AND MONTH==9 AND (DAY==5 OR DAY==18 OR DAY==0),1,0);DATE17101:=IF(YEAR==2017 AND MONTH==10 AND (DAY==10 OR DAY==20 OR DAY==0),1,0);DATE17111:=IF(YEAR==2017 AND MONTH==11 AND (DAY==6 OR DAY==20 OR DAY==28),1,0);DATE17121:=IF(YEAR==2017 AND MONTH==12 AND (DAY==6 OR DAY==21 OR DAY==0),1,0);DATE18011:=IF(YEAR==2018 AND MONTH==1 AND (DAY==16 OR DAY==0 OR DAY==0),1,0);DATE18021:=IF(YEAR==2018 AND MONTH==2 AND (DAY==8 OR DAY==22 OR DAY==0),1,0);DATE18031:=IF(YEAR==2018 AND MONTH==3 AND (DAY==1 OR DAY==19 OR DAY==26),1,0);DATE18041:=IF(YEAR==2018 AND MONTH==4 AND (DAY==9 OR DAY==24 OR DAY==0),1,0);DATE18051:=IF(YEAR==2018 AND MONTH==5 AND (DAY==3 OR DAY==15 OR DAY==31),1,0);DATE18061:=IF(YEAR==2018 AND MONTH==6 AND (DAY==0 OR DAY==0 OR DAY==0),1,0);DATE18071:=IF(YEAR==2018 AND MONTH==7 AND (DAY==0 OR DAY==0 OR DAY==0),1,0);DATE18081:=IF(YEAR==2018 AND MONTH==8 AND (DAY==0 OR DAY==0 OR DAY==0),1,0);DATE18091:=IF(YEAR==2018 AND MONTH==9 AND (DAY==0 OR DAY==0 OR DAY==0),1,0);DATE18101:=IF(YEAR==2018 AND MONTH==10 AND (DAY==0 OR DAY==0 OR DAY==0),1,0);DATE18111:=IF(YEAR==2018 AND MONTH==11 AND (DAY==0 OR DAY==0 OR DAY==0),1,0);DATE18121:=IF(YEAR==2018 AND MONTH==12 AND (DAY==0 OR DAY==0 OR DAY==0),1,0);DATE17012:=IF(YEAR==2017 AND MONTH==1 AND (DAY==0 OR DAY==0 OR DAY==0),1,0);DATE17022:=IF(YEAR==2017 AND MONTH==2 AND (DAY==3 OR DAY==15 OR DAY==0),1,0);DATE17032:=IF(YEAR==2017 AND MONTH==3 AND (DAY==1 OR DAY==7 OR DAY==23),1,0);DATE17042:=IF(YEAR==2017 AND MONTH==4 AND (DAY==10 OR DAY==20 OR DAY==0),1,0);DATE17052:=IF(YEAR==2017 AND MONTH==5 AND (DAY==4 OR DAY==17 OR DAY==0),1,0);DATE17062:=IF(YEAR==2017 AND MONTH==6 AND (DAY==15 OR DAY==0 OR DAY==0),1,0);DATE17072:=IF(YEAR==2017 AND MONTH==7 AND (DAY==7 OR DAY==0 OR DAY==0),1,0);DATE17082:=IF(YEAR==2017 AND MONTH==8 AND (DAY==16 OR DAY==0 OR DAY==0),1,0);DATE17092:=IF(YEAR==2017 AND MONTH==9 AND (DAY==1 OR DAY==12 OR DAY==25),1,0);DATE17102:=IF(YEAR==2017 AND MONTH==10 AND (DAY==16 OR DAY==26 OR DAY==0),1,0);DATE17112:=IF(YEAR==2017 AND MONTH==11 AND (DAY==14 OR DAY==23 OR DAY==0),1,0);DATE17122:=IF(YEAR==2017 AND MONTH==12 AND (DAY==4 OR DAY==15 OR DAY==0),1,0);DATE18012:=IF(YEAR==2018 AND MONTH==1 AND (DAY==10 OR DAY==25 OR DAY==0),1,0);DATE18022:=IF(YEAR==2018 AND MONTH==2 AND (DAY==13 OR DAY==27 OR DAY==0),1,0);DATE18032:=IF(YEAR==2018 AND MONTH==3 AND (DAY==12 OR DAY==21 OR DAY==0),1,0);DATE18042:=IF(YEAR==2018 AND MONTH==4 AND (DAY==2 OR DAY==11 OR DAY==25),1,0);DATE18052:=IF(YEAR==2018 AND MONTH==5 AND (DAY==11 OR DAY==23 OR DAY==0),1,0);DATE18062:=IF(YEAR==2018 AND MONTH==6 AND (DAY==7 OR DAY==0 OR DAY==0),1,0);DATE18072:=IF(YEAR==2018 AND MONTH==7 AND (DAY==0 OR DAY==0 OR DAY==0),1,0);DATE18082:=IF(YEAR==2018 AND MONTH==8 AND (DAY==0 OR DAY==0 OR DAY==0),1,0);DATE18092:=IF(YEAR==2018 AND MONTH==9 AND (DAY==0 OR DAY==0 OR DAY==0),1,0);DATE18102:=IF(YEAR==2018 AND MONTH==10 AND (DAY==0 OR DAY==0 OR DAY==0),1,0);DATE18112:=IF(YEAR==2018 AND MONTH==11 AND (DAY==0 OR DAY==0 OR DAY==0),1,0);DATE18122:=IF(YEAR==2018 AND MONTH==12 AND (DAY==0 OR DAY==0 OR DAY==0),1,0);DRAWICON(DATE17011 OR DATE17021 OR DATE17031 OR DATE17041 OR DATE17051 OR DATE17061 OR DATE17071 OR DATE17081 OR DATE17091 OR DATE17101 OR DATE17111 OR DATE17121 OR DATE18011 OR DATE18021 OR DATE18031 OR DATE18041 OR DATE18051 OR DATE18061 OR DATE18071 OR DATE18081 OR DATE18091 OR DATE18101 OR DATE18111 OR DATE18121,0,1);DRAWICON(DATE17012 OR DATE17022 OR DATE17032 OR DATE17042 OR DATE17052 OR DATE17062 OR DATE17072 OR DATE17082 OR DATE17092 OR DATE17102 OR DATE17112 OR DATE17122 OR DATE18012 OR DATE18022 OR DATE18032 OR DATE18042 OR DATE18052 OR DATE18062 OR DATE18072 OR DATE18082 OR DATE18092 OR DATE18102 OR DATE18112 OR DATE18122,0,2);DATE17123:=IF(YEAR==2017 AND MONTH==12 AND (DAY==6 OR DAY==0 OR DAY==0),1,0);DATE18023:=IF(YEAR==2018 AND MONTH==2 AND (DAY==8 OR DAY==0 OR DAY==0),1,0);DATE18033:=IF(YEAR==2018 AND MONTH==3 AND (DAY==26 OR DAY==0 OR DAY==0),1,0);DATE17114:=IF(YEAR==2017 AND MONTH==11 AND (DAY==14 OR DAY==0 OR DAY==0),1,0);DATE18014:=IF(YEAR==2018 AND MONTH==1 AND (DAY==10 OR DAY==0 OR DAY==0),1,0);DATE18034:=IF(YEAR==2018 AND MONTH==3 AND (DAY==12 OR DAY==0 OR DAY==0),1,0);DATE18044:=IF(YEAR==2018 AND MONTH==4 AND (DAY==11 OR DAY==0 OR DAY==0),1,0);DRAWICON(DATE17123 OR DATE18023 OR DATE18033,0,11);DRAWICON(DATE17114 OR DATE18014 OR DATE18034 OR DATE18044,0,12);DATE16055:=IF(YEAR==2016 AND MONTH==5 AND (DAY==16 OR DAY==0 OR DAY==0),1,0);DATE16085:=IF(YEAR==2016 AND MONTH==8 AND (DAY==2 OR DAY==0 OR DAY==0),1,0);DATE16095:=IF(YEAR==2016 AND MONTH==9 AND (DAY==27 OR DAY==0 OR DAY==0),1,0);DATE17015:=IF(YEAR==2017 AND MONTH==1 AND (DAY==19 OR DAY==0 OR DAY==0),1,0);DATE17085:=IF(YEAR==2017 AND MONTH==8 AND (DAY==14 OR DAY==0 OR DAY==0),1,0);DATE18025:=IF(YEAR==2018 AND MONTH==2 AND (DAY==8 OR DAY==0 OR DAY==0),1,0);DATE16076:=IF(YEAR==2016 AND MONTH==7 AND (DAY==7 OR DAY==0 OR DAY==0),1,0);DATE16086:=IF(YEAR==2016 AND MONTH==8 AND (DAY==17 OR DAY==0 OR DAY==0),1,0);DATE16116:=IF(YEAR==2016 AND MONTH==11 AND (DAY==22 OR DAY==0 OR DAY==0),1,0);DATE17036:=IF(YEAR==2017 AND MONTH==3 AND (DAY==23 OR DAY==0 OR DAY==0),1,0);DATE17116:=IF(YEAR==2017 AND MONTH==11 AND (DAY==14 OR DAY==0 OR DAY==0),1,0);DATE18046:=IF(YEAR==2018 AND MONTH==4 AND (DAY==11 OR DAY==0 OR DAY==0),1,0);DRAWICON(DATE16055 OR DATE16085 OR DATE16095 OR DATE17015 OR DATE17085 OR DATE18025,0,5);DRAWICON(DATE16076 OR DATE16086 OR DATE16116 OR DATE17036 OR DATE17116 OR DATE18046,0,4);DATE16097:=IF(YEAR==2016 AND MONTH==9 AND (DAY==29 OR DAY==0 OR DAY==0),1,0);DATE17017:=IF(YEAR==2017 AND MONTH==1 AND (DAY==19 OR DAY==0 OR DAY==0),1,0);DATE17087:=IF(YEAR==2017 AND MONTH==8 AND (DAY==10 OR DAY==0 OR DAY==0),1,0);DATE18027:=IF(YEAR==2018 AND MONTH==2 AND (DAY==6 OR DAY==0 OR DAY==0),1,0);DATE16118:=IF(YEAR==2016 AND MONTH==11 AND (DAY==11 OR DAY==0 OR DAY==0),1,0);DATE17038:=IF(YEAR==2017 AND MONTH==3 AND (DAY==17 OR DAY==0 OR DAY==0),1,0);DATE17118:=IF(YEAR==2017 AND MONTH==11 AND (DAY==2 OR DAY==0 OR DAY==0),1,0);DRAWICON(DATE16097 OR DATE17017 OR DATE17087 OR DATE18027,0,3);DRAWICON(DATE16118 OR DATE17038 OR DATE17118,0,14);
?
?來源:程序化99
文華技術(shù)人員：
不同軟件函數(shù)機(jī)制不同，加載效果可能略有差異，參考：

?

DATE17011:=IF(YEAR=2017 AND MONTH=1 AND (DAY=19),1,0);
DATE17021:=IF(YEAR=2017 AND MONTH=2 AND (DAY=6? OR DAY=21??? ),1,0);
DATE17031:=IF(YEAR=2017 AND MONTH=3 AND (DAY=3? OR DAY=10??? ),1,0);
DATE17041:=IF(YEAR=2017 AND MONTH=4 AND (DAY=5? OR DAY=19? OR DAY=25),1,0);
DATE17051:=IF(YEAR=2017 AND MONTH=5 AND (DAY=9 ),1,0);
DATE17061:=IF(YEAR=2017 AND MONTH=6 AND (DAY=2? OR DAY=29??? ),1,0);
DATE17071:=IF(YEAR=2017 AND MONTH=7 AND (DAY=24??????? ),1,0);
DATE17081:=IF(YEAR=2017 AND MONTH=8 AND (DAY=14? OR DAY=21??? ),1,0);
DATE17091:=IF(YEAR=2017 AND MONTH=9 AND (DAY=5 OR? DAY=18??? ),1,0);
DATE17101:=IF(YEAR=2017 AND MONTH=10 AND (DAY=10? OR DAY=20??? ),1,0);
DATE17111:=IF(YEAR=2017 AND MONTH=11 AND (DAY=6 OR? DAY=20? OR DAY=28),1,0);
DATE17121:=IF(YEAR=2017 AND MONTH=12 AND (DAY=6? OR DAY=21??? ),1,0);
DATE18011:=IF(YEAR=2018 AND MONTH=1 AND (DAY=16??????? ),1,0);
DATE18021:=IF(YEAR=2018 AND MONTH=2 AND (DAY=8 OR? DAY=22??? ),1,0);
DATE18031:=IF(YEAR=2018 AND MONTH=3 AND (DAY=1? OR DAY=19 OR? DAY=26),1,0);
DATE18041:=IF(YEAR=2018 AND MONTH=4 AND (DAY=9? OR DAY=24??? ),1,0);
DATE18051:=IF(YEAR=2018 AND MONTH=5 AND (DAY=3? OR DAY=15? OR DAY=31),1,0);
DATE18061:=IF(YEAR=2018 AND MONTH=6 ,1,0);
DATE18071:=IF(YEAR=2018 AND MONTH=7 ,1,0);
DATE18081:=IF(YEAR=2018 AND MONTH=8 ,1,0);
DATE18091:=IF(YEAR=2018 AND MONTH=9 ,1,0);
DATE18101:=IF(YEAR=2018 AND MONTH=10 ,1,0);
DATE18111:=IF(YEAR=2018 AND MONTH=11 ,1,0);
DATE18121:=IF(YEAR=2018 AND MONTH=12 ,1,0);
DATE17012:=IF(YEAR=2017 AND MONTH=1 ,1,0);
DATE17022:=IF(YEAR=2017 AND MONTH=2 AND (DAY=3 OR? DAY=15??? ),1,0);
DATE17032:=IF(YEAR=2017 AND MONTH=3 AND (DAY=1 OR? DAY=7? OR DAY=23),1,0);
DATE17042:=IF(YEAR=2017 AND MONTH=4 AND (DAY=10? OR DAY=20??? ),1,0);
DATE17052:=IF(YEAR=2017 AND MONTH=5 AND (DAY=4? OR DAY=17??? ),1,0);
DATE17062:=IF(YEAR=2017 AND MONTH=6 AND (DAY=15??????? ),1,0);
DATE17072:=IF(YEAR=2017 AND MONTH=7 AND (DAY=7??????? ),1,0);
DATE17082:=IF(YEAR=2017 AND MONTH=8 AND (DAY=16??????? ),1,0);
DATE17092:=IF(YEAR=2017 AND MONTH=9 AND (DAY=1? OR DAY=12? OR DAY=25),1,0);
DATE17102:=IF(YEAR=2017 AND MONTH=10 AND (DAY=16 OR? DAY=26??? ),1,0);
DATE17112:=IF(YEAR=2017 AND MONTH=11 AND (DAY=14 OR? DAY=23??? ),1,0);
DATE17122:=IF(YEAR=2017 AND MONTH=12 AND (DAY=4? OR DAY=15??? ),1,0);
DATE18012:=IF(YEAR=2018 AND MONTH=1 AND (DAY=10 OR? DAY=25??? ),1,0);
DATE18022:=IF(YEAR=2018 AND MONTH=2 AND (DAY=13 OR? DAY=27??? ),1,0);
DATE18032:=IF(YEAR=2018 AND MONTH=3 AND (DAY=12? OR DAY=21??? ),1,0);
DATE18042:=IF(YEAR=2018 AND MONTH=4 AND (DAY=2? OR DAY=11 OR? DAY=25),1,0);
DATE18052:=IF(YEAR=2018 AND MONTH=5 AND (DAY=11? OR DAY=23??? ),1,0);
DATE18062:=IF(YEAR=2018 AND MONTH=6 AND (DAY=7??????? ),1,0);
DATE18072:=IF(YEAR=2018 AND MONTH=7 ,1,0);
DATE18082:=IF(YEAR=2018 AND MONTH=8 ,1,0);
DATE18092:=IF(YEAR=2018 AND MONTH=9 ,1,0);
DATE18102:=IF(YEAR=2018 AND MONTH=10 ,1,0);
DATE18112:=IF(YEAR=2018 AND MONTH=11 ,1,0);
DATE18122:=IF(YEAR=2018 AND MONTH=12 ,1,0);
DRAWICON(DATE17011 OR? DATE17021 OR? DATE17031 OR? DATE17041 OR? DATE17051 OR? DATE17061 OR? DATE17071 OR? DATE17081? OR DATE17091 OR? DATE17101? OR DATE17111? OR DATE17121? OR DATE18011 OR? DATE18021 OR? DATE18031 OR? DATE18041 OR? DATE18051 OR? DATE18061 OR DATE18071 OR? DATE18081 OR? DATE18091 OR? DATE18101? OR DATE18111 OR? DATE18121,0,1);
DRAWICON(DATE17012? OR DATE17022? OR DATE17032? OR DATE17042? OR DATE17052 OR? DATE17062 OR? DATE17072? OR DATE17082 OR DATE17092 OR? DATE17102? OR DATE17112? OR DATE17122 OR? DATE18012? OR DATE18022 OR? DATE18032 OR? DATE18042 OR? DATE18052? OR DATE18062 OR? DATE18072? OR DATE18082? OR DATE18092 OR? DATE18102 OR? DATE18112 OR? DATE18122,0,2);
DATE17123:=IF(YEAR=2017 AND MONTH=12 AND (DAY=6??????? ),1,0);
DATE18023:=IF(YEAR=2018 AND MONTH=2 AND (DAY=8??????? ),1,0);
DATE18033:=IF(YEAR=2018 AND MONTH=3 AND (DAY=26??????? ),1,0);
DATE17114:=IF(YEAR=2017 AND MONTH=11 AND (DAY=14??????? ),1,0);
DATE18014:=IF(YEAR=2018 AND MONTH=1 AND (DAY=10??????? ),1,0);
DATE18034:=IF(YEAR=2018 AND MONTH=3 AND (DAY=12??????? ),1,0);
DATE18044:=IF(YEAR=2018 AND MONTH=4 AND (DAY=11??????? ),1,0);
DRAWICON(DATE17123 OR? DATE18023 OR? DATE18033,0,11);
DRAWICON(DATE17114? OR DATE18014 OR DATE18034 OR? DATE18044,0,12);
DATE16055:=IF(YEAR=2016 AND MONTH=5 AND (DAY=16??????? ),1,0);
DATE16085:=IF(YEAR=2016 AND MONTH=8 AND (DAY=2??????? ),1,0);
DATE16095:=IF(YEAR=2016 AND MONTH=9 AND (DAY=27??????? ),1,0);
DATE17015:=IF(YEAR=2017 AND MONTH=1 AND (DAY=19??????? ),1,0);
DATE17085:=IF(YEAR=2017 AND MONTH=8 AND (DAY=14??????? ),1,0);
DATE18025:=IF(YEAR=2018 AND MONTH=2 AND (DAY=8??????? ),1,0);
DATE16076:=IF(YEAR=2016 AND MONTH=7 AND (DAY=7??????? ),1,0);
DATE16086:=IF(YEAR=2016 AND MONTH=8 AND (DAY=17??????? ),1,0);
DATE16116:=IF(YEAR=2016 AND MONTH=11 AND (DAY=22??????? ),1,0);
DATE17036:=IF(YEAR=2017 AND MONTH=3 AND (DAY=23??????? ),1,0);
DATE17116:=IF(YEAR=2017 AND MONTH=11 AND (DAY=14??????? ),1,0);
DATE18046:=IF(YEAR=2018 AND MONTH=4 AND (DAY=11??????? ),1,0);
DRAWICON(DATE16055 OR? DATE16085 OR? DATE16095? OR DATE17015 OR? DATE17085? OR DATE18025,0,5);
DRAWICON(DATE16076? OR DATE16086 OR? DATE16116 OR? DATE17036? OR DATE17116 OR? DATE18046,0,4);
DATE16097:=IF(YEAR=2016 AND MONTH=9 AND (DAY=29??????? ),1,0);
DATE17017:=IF(YEAR=2017 AND MONTH=1 AND (DAY=19??????? ),1,0);
DATE17087:=IF(YEAR=2017 AND MONTH=8 AND (DAY=10??????? ),1,0);
DATE18027:=IF(YEAR=2018 AND MONTH=2 AND (DAY=6??????? ),1,0);
DATE16118:=IF(YEAR=2016 AND MONTH=11 AND (DAY=11),1,0);
DATE17038:=IF(YEAR=2017 AND MONTH=3 AND (DAY=17),1,0);
DATE17118:=IF(YEAR=2017 AND MONTH=11 AND (DAY=2),1,0);
DRAWICON(DATE16097 OR? DATE17017? OR DATE17087 OR? DATE18027,0,3);
DRAWICON(DATE16118? OR DATE17038 OR? DATE17118,0,14);
?