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

[µo°Ý] «ç¼Ë¥Î¨ç¼Æ§â¨C¤K­Ó¬P´Á¬°¤@­Ó´`Àô¦P®ÉÅÜ´«ª¬ºAªº±ø¥ó®æ¦¡¤Æ¡H

¦^´_ 10# maiko

³Ìªñ¦£µyºC¨Ó°Q½×
¦]¬°±Æ¦CÅÞ¿è¤W¤´¦³¨Ç¥¼¸Ñ¡A¿ð¿ð¥¼¯à¤U¤â¡A
¤p®§³¡¤À«Øij¬P´Á¤G®É¥ý³]¬°Âù©P¥ð¡A¸ò§Aªºªì¨B­n¨D¬Û¦P

¤p®§B2®æ¦¡¤Æ¤½¦¡
=N(MOD(INT((B2-$B$2)/56)+MATCH($J$2,$B$1:$H$1,)-0,7)=WEEKDAY(B2,3)) * (MOD(INT((B2-$B$2)/7),2)=IF(WEEKDAY(B2,3)=1,1,IF($K$2=8,1,0)))
   
¤½¦¡»¡©ú =(¬P´Á§PÂ_) * (³æÂù©P§PÂ_)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD