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

cubela

¦³¤@¨Ç¥X³f¤é´Á·Q²Î¤@µ²ºâ¤é
½Ð°Ý­n¦p¦ó¨Ï¥Î©O?
¨Ò¦p:
¥X³f¤é¦b20140925~20141024¤§¶¡ªº¤é´Á
·Q¦A¥Î¤@­Óµ²ºâ¤é²Î¤@¬°2014/10/31

ML089

=EOMONTH(¤é´Á, 1-(DAY(¤é´Á)<25))

cubela

=EOMONTH(¤é´Á, 1-(DAY(¤é´Á)
ML089 µoªí©ó 2014-10-31 14:26

  ·PÁÂ~¥i¥HÅo

½Ð°Ý­þ­Ó1-¬O¬Æ»ò·N«ä©O?

ML089

¦^´_ 3# cubela

=EOMONTH(¤é´Á, 1-(DAY(¤é´Á)<25))

¤é´Á<25®É¡A
    1-(DAY(¤é´Á)<25) = 1-TRUE = 1-1 = 0
    =EOMONTH(¤é´Á, 0)

¤é´Á>=25®É¡A
    1-(DAY(¤é´Á)<25) = 1-FALSE = 1-0 = 1
    =EOMONTH(¤é´Á, 1)

cubela

¦^´_  cubela

=EOMONTH(¤é´Á, 1-(DAY(¤é´Á)
ML089 µoªí©ó 2014-10-31 23:02

    ¨ü±Ð¤F¡A«D±`·PÁÂ!!!¤S¾Ç¨ì¤@©Û
¥t¥~½Ð±Ð¦pªG¤£¬O­n¤ë©³ªº¸Ü¡A¨Ò¦p¬O28¸¹ªº¸Ü¡A¤@¼Ë¬O³o­Ó¨ç¼Æ¶Ü?
ÁÙ¬O­n¨Ï¥Î¨ä¥L¨ç¼Æ?

ML089

²Î¤@µ²ºâ¤é§ï¬°28¤é¦p¤U

A3¬°¤é´Á

=DATE(YEAR(A3),MONTH(A3)+(DAY(A3)>24),28)

cubela

²Î¤@µ²ºâ¤é§ï¬°28¤é¦p¤U

A3¬°¤é´Á

=DATE(YEAR(A3),MONTH(A3)+(DAY(A3)>24),28)
ML089 µoªí©ó 2014-11-1 06:37

    §Ú·|¤F¡A«D±`·PÁÂ
¥t¥~¤]¬d¤F¨ä¥L¨ç¼Æ¡AºCºC¬ã¨s¤¤
http://office.microsoft.com/zh-tw/excel-help/HP010079181.aspx?CTT=1