我编制出来了,比较麻烦,请各位朋友帮我简化一下:IF(AND(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7,A1=DATE(2012,1,2),A1=DATE(2012,1,25),A1=DATE(2012,1,26),A1=DATE(2012,1,27),A1=DATE(2012,4,2),A1=DATE(2012,4,3),A1=DATE(2012,4,30),A1=DATE(2012,6,25)),A1<>DATE(2012,1,1),A1<>DATE(2012,1,22),A1<>DATE(2012,6,23),A1<>DATE(2012,1,21),A1<>DATE(2012,1,29),A1<>DATE(2012,3,31),A1<>DATE(2012,4,1),A1<>DATE(2012,4,28)),"休",IF(OR(A1=DATE(2012,1,1),A1=DATE(2012,1,22),A1=DATE(2012,1,23),A1=DATE(2012,1,24),A1=DATE(2012,4,4),A1=DATE(2012,5,1),A1=DATE(2012,6,23)),"法","")) |