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

¦p¦ó¨D¥X¹ê»Ú¼·´Ú¤é¤Î³øªí¤é,¥t¥~,­Y¹w­p¼·´Ú¤é¬°©_¼Æ¤ë,¦p¦ó³]©w®æ¦¡¤Æ±ø¥ó³]©³¦â

¦p¦ó¨D¥X¹ê»Ú¼·´Ú¤é¤Î³øªí¤é,¥t¥~,­Y¹w­p¼·´Ú¤é¬°©_¼Æ¤ë,¦p¦ó³]©w®æ¦¡¤Æ±ø¥ó³]©³¦â

¦p¦ó¨D¥X¹ê»Ú¼·´Ú¤é¤Î³øªí¤é,¥t¥~,­Y¹w­p¼·´Ú¤é¬°©_¼Æ¤ë,¦p¦ó³]©w®æ¦¡¤Æ±ø¥ó³]©³¦â
°ÝÃD¸Ô¦pªþ¥ó

Book1.zip (6.76 KB)

joyce

¦^´_ 1# leiru
°ÝÃD¤@¡G¦p¦ó³]©w¹ê»Ú¼·´Ú¤é¤Î³øªí¤é
B2=A2+(WEEKDAY(A2,2)>5)*(8-WEEKDAY(A2,2)) ©¹¤U©Ô
C2=B2+1+(WEEKDAY(B2+1,2)>5)*(8-WEEKDAY(B2+1,2)) ©¹¤U©Ô

¥t, ¹ï©ó C Äæ §Ú¤]³]¬°¸õ¹L¬P´Á¤»»P¬P´Á¤Ñ.


°ÝÃD¤G : ¥H¹w­p¼·´Ú¤é§@§PÂ_¡A­Y¬°©_¼Æ¤ë¡A«hAÄæ¦ÜCÄæ®æ¦¡¤Æ±ø¥óªº©³¦â¬°¶À¦â
B2 ~ C10 :
¤½¦¡¬°  =MOD(MONTH($A2),2)<>0
¹Ï¼Ë³]¬°¶À¦â
Book1-A.zip (7.25 KB)

TOP

luhpro¤j±z¦n

·Q½Ð°Ýmodªº¨ç¼Æ¬O¥i¥H°µ«Ü¦hÀ³¥Î¶Ü

¥Ø«e¤p§Ìª¾¹DªºÀ³¥Î¥u¦³°¸¼Æ¦C(Äæ)¸ò©_¼Æ¦C(Äæ)ªºÀ³¥Î

=mod(row(),2)=0              =mod(row(),2)=1
=mod(column(),2)=0          =mod(column(),2)=1

¬O§_¦³¨ä¥LªºÀ³¥Î¥i¥H°Ñ¦Ò©O

TOP

¦^´_ 2# luhpro

ÁÂÁ¦^ µª.
¤´¦³°ÝÃD,BÄæ°£¤F¸õ¹L¶g¤»¤Î¶g¤é¥~,¤]¤£­n¦b°ê©w°²¤é,¨Ò¦p:B12Àx¦s®æªºÀ³§ï¬°9/23,¦]¬°9/19¬°¤¤¬î¸`...
¥t¥~,CÄæ¥Ø«e¦³§t¨ì¶g¤»©Î¶g¤é,µL©Ò¿×,¨ä­È¬O¹ê»Ú¼·´Ú¤é¥[1¤Ñ§Y¥i....

Book1-A2.zip (8.58 KB)

joyce

TOP

¦^´_ 4# leiru
¥²¶·¦³°²¤éªí¤Î¸É¤W¯Zªí
Book1-A2.zip (10.43 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

luhpro¤j±z¦n

·Q½Ð°Ýmodªº¨ç¼Æ¬O¥i¥H°µ«Ü¦hÀ³¥Î¶Ü

¥Ø«e¤p§Ìª¾¹DªºÀ³¥Î¥u¦³°¸¼Æ¦C(Äæ)¸ò©_¼Æ¦C(Äæ)ªºÀ³ ...
HCG10G8bear µoªí©ó 2013-11-1 11:54

mod ¬O¨D¾l¼Æ,
°ò¥»¤W³Q°£¼Æ¬O¦h¤Ö,´N¦³¦h¤Ö­Ó¤£¦Pªº¾l¼Æ(0 ~ ³Q°£¼Æ´î 1).

§Ú³Ì±`°µªºÀ³¥Î¬O®M¥Î¦b®æ¦¡¤Æ±ø¥óªº³]©w¤W,
¨Ò¦p : ¤½¦¡=MOD(ROW(),5)=0
¥B³]¹Ï¼Ë¬°¶À¦â®É,
«h¨C­Ó²Ä 5 ¦C³£·|Åܦ¨¶À¦â©³¦â,
³o¼Ë¦bªí®æ¤W·|¸û®e©ö¿ëÃѦì¸m¤Î°µ¾A·íªº°Ï¹j.

¥t¤@­Ó¨Ò¤l´N¬O
¤½¦¡=(WEEKDAY(A1,2)>5) ¥B¥ç³]¤F¹Ï¼Ë®É,
³o¼Ë¨C­Ó¬P´Á¤»¤é³£·|¦³©³¦â,
¤]¬O­Ó¿ô¥Øªº°Ï¹j.

TOP

¦^´_ 6# luhpro

ÁÂÁ¤j¤j¤£§[±Ð¾É

¨ü±Ð¤F

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD