ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

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

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

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

²Î¤@µ²ºâ¤é§ï¬°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

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2014-11-1 06:44 ½s¿è

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

A3¬°¤é´Á

=DATE(YEAR(A3),MONTH(A3)+(DAY(A3)>24),28)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  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¨ç¼Æ?

TOP

¦^´_ 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)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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



  ·PÁÂ~¥i¥HÅo

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

TOP

=EOMONTH(¤é´Á, 1-(DAY(¤é´Á)<25))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD