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

[µo°Ý] ½Ð±Ð¦p¦ó¹ï¤ñ¬d¸ß¦hµ§¤é´Á¸ê®Æ¡A¨ú¥X¬Û²Å¤é´Áªº¯S©w¨ê¥d¸ê®Æ

¦^´_ 10# jackson7015

C18 = 2014/10/30
C19 = 1900/131

C19ªº¸ê®Æ¦³»~³y¦¨¿ù»~

­Y¬O¨C­Ó¤ë³B²z±¡ªp¥u­n¤ñ¹ï "¤é" ¤£ºÞ¦~¤ë¥i¥H¨Ï¥Î¤U¦C¤½¦¡
=MOD(LOOKUP(DAY(C8)+0.5,DAY(TEXT(S$2:S$99,"!r0-00-00"))+T$2:T$99),1)

­Y¬OC19ªº¸ê®Æ¦³»~¯à­×¥¿®É¡A¥i¥Î¤U¦C¤½¦¡
=MOD(LOOKUP(C8+0.5,TEXT(S$2:S$99,"!r0-00-00")+T$2:T$99),1)

MOD()¬O±N¤é´Á¥h±¼³Ñ®É¶¡¡Aµø±¡ªpMOD()¤]¥i¥H¤£¥Î´N¦^¦^¶Ç ¤é´Á+®É¶¡
=LOOKUP(C8+0.5,TEXT(S$2:S$99,"!r0-00-00")+T$2:T$99)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 11# ML089
·PÁÂML089ª©¥Dªº«ü¾É

¥X¿ùªº­ì¦]¬O¦Û¤vª½±µKeyin¤é´Á¡A¨S¦³«ö·Ó®æ¬O¿é¤J
·PÁ´£¿ô¿ù»~¡A§ó¥¿«á¤wµL°ÝÃD¤F

·PÁ´£¨Ñ¥t¥~ªº¤½¦¡¡A´ú¸Õ«á³£¨S¦³°ÝÃD

¦A¦¸ÁÂÁ¦U¦ì«e½úªº«ü¾É

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD