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

[µo°Ý] ²Î­p»P¤ë¥÷Åã¥Ü°ÝÃD

[µo°Ý] ²Î­p»P¤ë¥÷Åã¥Ü°ÝÃD


¤p©f¹J¨ì¥H¤W2­Ó°ÝÃD¡A¥i¥H¦Vºô¤j­Ì¨D¸Ñ¬Ý¬Ý¶Ü~~~~~~3§J´µ

´ú¸ÕÀÉ.rar (9.18 KB)
*¦v¤k¤@ªTµL»~*

¦^´_ 4# ­ã´£³¡ªL


   ­ã¤j~~~¦A¦¸·PÁÂÀ°¦£¤§¥~¡A¦Ó¥B­ã¤j¯uªº¶W²Ó¤ßªº­C!!!µ¹§A¤@­ÓÆg
*¦v¤k¤@ªTµL»~*

TOP

¦^´_ 2# ML089


   M¤j~~~«D±`·PÁ¼ö¤ßÀ°¦£³á!!!
*¦v¤k¤@ªTµL»~*

TOP

´ú¸Õ¤@
¢Ï¢°¡G=MOD(MONTH(NOW())+COLUMN(A$1)-2,12)+1&"¤ë"

´ú¸Õ¤G
¢Ò¢±¡G
=COUNT(MATCH(LEFT(A2,FIND("_",A2&"_")-1),²M³æ!A:A,)/(B2="¶i½u"))

©m¦W¤ñ¹ï¡A¥ÎFIND®É¡A¶·ª`·N¡e³¯¤ß¡f»P¡e³¯¤ß¦p¡f·|²V²c¡A¥ÎMATCH¸ûÄYÂÔ¡I
¡@
¡@

TOP

°ÝÃD¤G

D2 =IF(B2<>"¶i½u",0,COUNT(FIND(©m¦W,A2)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

°ÝÃD¤@
A1 =TEXT(EOMONTH(NOW(),COLUMN(A1)-1),"m¤ë")
¥k©Ô


¥tÃþ«ä¦Ò

A1 =NOW() ©Î¦Û¦æ¿é¤J¤é´Á¡AÀx¦s®æ®æ¦¡³]¬° ¼Æ­È-¦Û­q-"m¤ë"

A2 =EOMONTH(A1,1)
¥k©Ô

©Î

A2 =A1+28
¥k©Ô
­­¨î: ¤@¯ë¤ë¥­§¡30¤Ñ¡A+28¤Ñ·|·l¥¢2¤Ñ¡A©Ò¥H¤£¯à¶W¹L14­Ó¤ë¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : µoµÊ®ð¬Oµu¼ÈªºµoºÆ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD