[µo°Ý] ¤é´ÁÁôÂðÝÃD

mei27

¦U¦ì¦n¡A½Ð°Ý¤@¤U¡A§Ú§Q¥Î¤F¤§«eª©¤W°ª¤âªº¤½¦¡¥h§ï¤F¤@¤U¡A
Åýc3¿é¤J07/01¡A«á­±ªº¤é´Á´N·|¸òµÛ©µÄò¤U¥h¡A
=TEXT(DATE(2013,LEFT(C3,2),RIGHT(C3,2)+1),"mm/dd")

¥i¬O·Q½Ð°Ý¡A¦³¨S¦³¿ìªkÅý³Ì«á¤@®æ¤]´N¬O²Ä31¤Ñ¨º®æ¡A
¦pªG¬O¤p¤ë(2¡B4¡B6¡B9¡B11¤ë)¡A´Nª½±µÁôÂ䣭nÅã¥Ü¡A¦Ó¤£¬O¸õ¤U­Ó¤ëªº1¸¹¡C
ÁÂÁÂ~

mei27

·Q¤F¦n¤[²×©ó¸Ñ¥X¨Ó¤F¡A¥i¬OÁ`ı±o¤S¯ä¤Sªø¡A
=IF(OR(LEFT(AF3,2)="02",LEFT(AF3,2)="04",LEFT(AF3,2)="06",LEFT(AF3,2)="09",LEFT(AF3,2)="11")=TRUE,"",TEXT(DATE(2013,LEFT(AF3,2),RIGHT(AF3,2)+1),"mm/dd"))

¤£ª¾¹D¨º­Ó¡yor¡z¦³¨S¦³Â²¤Æªº¼gªk¡K

p212

¦^´_ 2# mei27
½Ð°Ñ¦Ò
D3Àx¦s®æ¿é¤J
=IF(C3="","",IF(DATE(2013,LEFT(C3,2),RIGHT(C3,2)+1)=DATE(2013,LEFT($C$3,2)+1,1),"",TEXT(DATE(2013,LEFT(C3,2),RIGHT(C3,2)+1),"mm/dd")))
¦V¥k½Æ»s¤½¦¡¦ÜAG3Àx¦s®æ

mei27

¦^´_ 3# p212


¥i¥H¤F­C¡A³s2¤ë³£¯à°÷¥¿½TÅã¥Ü¤Ñ¼Æ¡A
¤Ó¼F®`¤F¡A§Ú­n¨Ó¦n¦n¬ã¨s¤@¤U³o­Ó¤½¦¡¡AÁÂÁ§A®@¡I

ANGELA

=IF(AND(DAY(--AF3)=30,--AF3+1=EOMONTH(--AF3,0)+1),"",TEXT(AF3+1,"MM/DD"))

mei27

¦^´_ 5# ANGELA


Angela¤j¡A§Ú§â³o­Ó¤½¦¡©ñ¦bAG3¡Aµ²ªG¨S¦³®ÄªG§o¡A·|¤£·|¬O¦]¬°§Úªºª©¥»¬O2003ªºÃö«Y©O¡H

ANGELA

EOMONTH()¬O¤ÀªR¤u¨ã½c¼W¯q¶°¨ç¼Æ
  ¤u¨ã=>¼W¯q¶°=>¤ÀªR¤u¨ã½c  ¿ï¨ú

mei27

¦^´_ 7# ANGELA


­ì¨Ó¦p¦¹¡A¤Ä¿ï¤§«á°õ¦æ´N¥¿±`¤F¡A¨ü±Ð¤F¡A·PÁÂ~