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

¦p¦ó¨Ï¥Î¨ç¦¡Åýexcel¦Û°Ê§PÂ_¤Ñ¼Æ

¦p¦ó¨Ï¥Î¨ç¦¡Åýexcel¦Û°Ê§PÂ_¤Ñ¼Æ

1¤ë¥÷ ¶Ç¦^31
2012.02 ¶Ç¦^29
3¤ë¶Ç¦^31
¦³¤°»ò²{¦¨ªº¨ç¼Æ©Î¤°»ò§Þ¥©¥i¥H¹F¨ì³o¼Ëªº®ÄªG¶Ü?

¦^´_ 1# vvcvc

¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥H«e¤@ª½·Q¤£¨ìday³o­Ó¨ç¼Æ¯à«ç»ò¹B¥Î
­ì¨ÓÁÙ¥i¥H³o¼Ë¤l¬¡¥Î
ÁÂÁª©¥Dªº«ü¾É

¥t½Ð±Ð¤@­Ó°ÝÃD¡A­n«ç»ò§â¦r¦ê¤¤ªº¼Æ¦r¤ÀÂ÷¥X¨Ó
3°¦¦Ñªê ¶Ç¦^3
abc123 ¶Ç¦^123
¤Ñ¤W­¸¹L7°¦®üÅà ¶Ç¦^7

TOP

¸Ñ1
­É¥Î¶W¯Åª©¥D¹Ï¤ù¤@¥Î C2 ¤½¦¡ =DAY(DATE(A2,B2+1,))
¸Ñ3¼Ó
°²³]­ì¸ê®Æ¦bA1
B1 ¤½¦¡ {=LOOKUP(9^9,--MID(A1,MIN(FIND(ROW($1:$10)-1,A1&1234567890)),ROW($1:$20)))}

TOP

·PÁ¦^ÂÐ
DAY(DATE(A2,B2+1,))
¤ñ¸û¤è«K¡A¤]§ó¼u©Ê
¥i¬O¬°¤°»ò¤ë¥÷¤´­n¥[1?

¤ñ¦p»¡§Úª½±µ¿é¤J¼Æ¦rDAY(DATE(2012,2,))
ª½Ä±·|»{¬°¬O2¤ë¥÷¡A¥i¬O±o¨ìªºµ²ªG«o¬O1¤ë¥÷
³o¬O¤°»ò­ì¦]?

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-1-3 17:14 ½s¿è

¦^´_ 5# vvcvc

¤ë¥÷ªº¤é¬°0´N¬O«e¤@­Ó¤ëªº³Ì«á¤@¤Ñ

3#°Ñ¦Ò
http://forum.twbts.com/thread-8550-1-3.html
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2013-1-3 17:03 ½s¿è
·PÁ¦^ÂÐ
DAY(DATE(A2,B2+1,))
¤ñ¸û¤è«K¡A¤]§ó¼u©Ê
¥i¬O¬°¤°»ò¤ë¥÷¤´­n¥[1?

¤ñ¦p»¡§Úª½±µ¿é¤J¼Æ¦rDAY ...
vvcvc µoªí©ó 2013-1-3 16:39


DAY(DATE(A2,B2+1,))
©p¥Î·Æ¹««ö¥ªÁä¨ê¤½¦¡¤¤ªº A2 ¦A«ö F9 ¬Ýµ²ªG,¦P²z B2 ¦A«ö F9 ¬Ýµ²ªG «D±`¯«©_ªº
¦A´£¨Ñ¥t¤@«äºû  
=DAY(Eomonth(DATE(A2,B2,1),0))
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_  vvcvc

¤ë¥÷ªº¤é¬°0´N¬O«e¤@­Ó¤ëªº³Ì«á¤@¤Ñ

3#°Ñ¦Ò
Hsieh µoªí©ó 2013-1-3 16:49



    ­ì¨Ó¤ë¥÷ªº¤é¬°¹s®É¡A´N¬O«e¤@­Ó¤ëªº³Ì«á¤@¤Ñ¡AÁÂÁ¡A°O°_¨Ó¤F!
¤H¥Í¥u¦³¤T¤Ñ¡A¥u¦³¬¡¦b¤µ¤Ñ³Ì½ñ¹ê

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD