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

§ä­þ¤@¤Ñ

§ä­þ¤@¤Ñ

¦U¦ì«e½ú§A­Ì¦n!
         °ÝÃD¦pªþÀÉ»¡©ú
         ½Ðª¾¹Dªº«e½ú,¤£§[½ç±ÐÁÂÁ¦A¤T!!

Leo31.rar (4.08 KB)

¦^´_ 1# myleoyes
A1=LOOKUP(--(TEXT(TODAY(),"yyyy-m")&"-10"),$A$4:$A$50)
A2°}¦C¤½¦¡
=INDEX($A$4:$A$50,MATCH(1,1/(($A$4:$A$50)>=--(TEXT(TODAY(),"yyyy-m")&"-11")),0))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh
°¸¹³«e½ú!ÁÂÁÂ!!½Ð¦AÀ°¦£³o2­ÓÀÉ®×
        B1{=INDEX($A$4:$A$65536,MATCH(1,1/(($A$4:$A$65536)>=--(TEXT(TODAY(),"yyyy-m")&"-1")),0))]
        B2¤½¦¡
        C1¤½¦¡
        C2¤½¦¡
       ¨¯­WÅo!ÁÂÁ¦A¤T!!

Leo31-1.rar (4.12 KB)

Leo31-2.rar (3.93 KB)

TOP

°}¦C¤½¦¡
b1=MIN(IF((YEAR(A4:A50)=2012)*(MONTH(A4:A50)=12),A4:A50))
b2=MAX(IF((YEAR(A5:A51)=2012)*(MONTH(A5:A51)=12),A5:A51))
¦~,¤ë¥i¨Ì»Ý­n¦Ó§ï

TOP

¦^´_ 4# ANGELA
«e½ú!ÁÂÁÂ!!§A¥i¯à»~¸Ñ¤p§Ìªº»Ý¨D..
         ¦~,¤ë¬O¤£»Ý­n­×§ï¦p°Êµeªº
         D1:D2©ÒÅã¥Ü½Ð¦A±Ð¾ÉÁÂÁ¦A¤T!!
           B1{=INDEX($A$4:$A$65536,MATCH(1,1/(($A$4:$A$65536)>=--(TEXT(TODAY(),"yyyy-m")&"-1")),0))}
           B2=?!
        ¦ÓC1{=LOOKUP(--(TEXT(YEAR(TODAY())&"/7/31","yyyy-m")&"-31"),$A$4:$A$65536)}     
            C2={INDEX(A$4:$A$65536,MATCH(1,1/(($A$4:$A$65536)>=--(TEXT(YEAR(TODAY())&"/8/1","yyyy-m")&"-                    1")),0))}
            ´ú¸Õµ²ªG¦n¹³¬OOK!

Leo31-1.gif (579.49 KB)

Leo31-1.gif

TOP

¦^´_ 5# myleoyes

·í¤ë²Ä¤@¤Ñ°}¦C¤½¦¡
=MIN(IF(TEXT($A$4:$A$50,"yyyymm")=TEXT(TODAY(),"yyyymm"),$A$4:$A$50,""))
·í¤ë³Ì«á¤@¤Ñ°}¦C¤½¦¡  
=MAX(IF(TEXT($A$4:$A$50,"yyyymm")=TEXT(TODAY(),"yyyymm"),$A$4:$A$50,""))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦U¦ì«e½ú§A­Ì¦n!
         °ÝÃD¦pªþÀÉ»¡©ú
         ½Ðª¾¹Dªº«e½ú,¤£§[½ç±ÐÁÂÁ¦A¤T!!
myleoyes µoªí©ó 2012-12-10 21:56


B1

{=MIN(IF(MONTH(A$4:A$50)=MONTH(TODAY()),A$4:A$50))}

B2

{=MAX((MONTH(A$4:A$50)=MONTH(TODAY()))*A$4:A$50)}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 6# Hsieh
°¸¹³«e½ú!¯uªº¬O¥Ì®¦...ÁÂÁ¦A¤T!!

TOP

¦^´_ 7# zz5151353
«e½ú!ÁÂÁÂ!!µ{¦¡B1¦³»~?!
        ¦pªþ°Êµe©Ò¥Ü!ÁÙ¦³°ÝÃD½Ð±Ð°}¦C¤½¦¡¬°¦ó?
       ¦p¦¹¯Ó¶O¸ê·½,¨C¨C¦³°}¦C¤½¦¡¥B¦C¼Æ¤@¦h¤§¤U
      °õ¦æµ{¦¡´N·|Åܱo«ÜºC¥i¦³§ïµ½¤èªk
      ½Ð¤£§[«ü¾ÉÁÂÁ¦A¤T!!

TOP

¦^´_ 9# myleoyes
«e½ú!¬p¶Õ!!§Ñ¤FªþÀÉ

Leo31-1.gif (355.72 KB)

Leo31-1.gif

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD