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

myleoyes

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

oobird

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

ANGELA

¦^´_ 1# myleoyes


    AAA.zip (4.85 KB)

¤U¸ü¦¸¼Æ: 8

2012-7-2 13:56

½Ð°Ñ¦Ò

myleoyes

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

myleoyes

¦^´_ 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))))))))

Hsieh

¦^´_ 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))))

myleoyes

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