[µo°Ý] IF AND OR ¦p¦ó¾A¥Î¡H VBA, AND

Lin-excel

­Y·Q¥ÎVBA ªºIF¥yªk¡A¨Ó§PÂ_¨C©u°]³ø¦Û°Ê§ó·s¡A¸Ó¦p¦ó¼g¡H
If .Cells(r, "EN") = "" Or (Date >= DateSerial(Year(Date), 3, 31) And Date < DateSerial(Year(Date), 4, 1)) Or (Date >= DateSerial(Year(Date), 5, 14) And Date < DateSerial(Year(Date), 5, 16)) Or (Date >= DateSerial(Year(Date), 8, 14) And Date < DateSerial(Year(Date), 8, 16)) Or (Date >= DateSerial(Year(Date), 11, 14) And Date < DateSerial(Year(Date), 11, 16)) Then Exit Sub
¥X²{µ{¦¡ª«¥ó©w¸q¿ù»~¡A½Ð«e½ú°ª¤â«ü¥¿¡I

Lin-excel

ÁÂÁª©¥D½ç±Ð¡A·P®¦¡I