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

§ä¤U¤@­Ó¬P´Á¤»

§ä¤U¤@­Ó¬P´Á¤»

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

Leo26.rar (6.22 KB)

=TEXT(CEILING((Edate(A7,3)-8)/7,1)*7+7,"e/m/d")

TOP

¦^´_ 1# myleoyes


    AAA.zip (4.85 KB)
½Ð°Ñ¦Ò

TOP

¦^´_ 2# oobird
¶Wª©ªGµM§Q®`!¤p§Ì¬Q©]·Q«Ü¤[²×©ó¸Ñ¥X¨ÓÁÂÁ¦A¤T!!

TOP

¦^´_ 3# ANGELA
«e½ú!!ÁÂÁ¦A¤T!!®M¥Î¶Wª©ªº¤½¦¡¸Ñ¥X¦p¤U!
                 B7=IF(A1>EDATE(A7,9),TEXT(CEILING((EDATE(A7,12)-8)/7,1)*7+7,"e/m/d"),IF(TEXT(CEILING((EDATE(A7,9)-8)/7,1)*7+7,"e/m/d")=TEXT(A1,"e/m/d"),"²Ä4¦¸ºû­×",IF(TEXT(CEILING((EDATE(A7,6)-8)/7,1)*7+7,"e/m/d")=TEXT(A1,"e/m/d"),"²Ä3¦¸ºû­×",IF(A1>EDATE(A7,6),TEXT(CEILING((EDATE(A7,9)-8)/7,1)*7+7,"e/m/d"),IF(TEXT(CEILING((EDATE(A7,3)-8)/7,1)*7+7,"e/m/d")=TEXT(A1,"e/m/d"),"²Ä2¦¸ºû­×",IF(A1>EDATE(A7,3),TEXT(CEILING((EDATE(A7,6)-8)/7,1)*7+7,"e/m/d"),IF(A1>A7,TEXT(CEILING((EDATE(A7,3)-8)/7,1)*7+7,"e/m/d"),IF(TEXT(CEILING((EDATE(A7,0)-8)/7,1)*7+7,"e/m/d")=TEXT(A1,"e/m/d"),"²Ä1¦¸ºû­×",A7))))))))

TOP

¦^´_ 5# myleoyes
B7=IF(A1>EDATE($A$7,9)-(WEEKDAY(EDATE($A$7,9),2)-6),EDATE($A$7,9)-(WEEKDAY(EDATE($A$7,9),2)-6),IF(ISNUMBER(MATCH(A1,EDATE($A$7,{0,3,6,9})-(WEEKDAY(EDATE($A$7,{0,3,6,9}),2)-6),0)),"²Ä"&LOOKUP(A1,EDATE($A$7,{0,3,6,9})-(WEEKDAY(EDATE($A$7,{0,3,6,9}),2)-6),{1,2,3,4})&"¦¸ºû­×",INDEX(EDATE($A$7,{9,6,3,0})-(WEEKDAY(EDATE($A$7,{9,6,3,0}),2)-6),MATCH(A1,EDATE($A$7,{9,6,3,0})-(WEEKDAY(EDATE($A$7,{9,6,3,0}),2)-6),-1))))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh
    °¸¹³«e½ú!¯u¬OÁÂÁÂ!!­ì¥»¥¿¬°C7ªº¤½¦¡µo·T
   ¤½¦¡¬JµM¥i¤@½bÂùÀJ¤Ó§Q®`Åo!!ÁÂÁ¦A¤T!!

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD