使ç¨ããé¢æ°ã¨æ©è½ 使ç¨ããé¢æ°ï¼IFãMONTH WEEKDAYãCOLUMNãROWããMATCH 使ç¨ããæ©è½ï¼æ¥ä»ã®è¡¨ç¤ºå½¢å¼ï¼ã¦ã¼ã¶ã¼è¨å®)ã罫ç·ãååã®å®ç¾©ãæ¡ä»¶ä»ãæ¸å¼ ãªãããã®ãã¼ã¸ã§ã¯1ã¤ã®æ°å¼ã§ä½æããä¾ãæ¸ãã¦ãã¾ããæ°å¼ãããé£è§£ã«ãªã£ã¦ãã¾ãã®ã§ã注æãã ããã ç°¡æãªæ°å¼ã§ã®ä½æãå¯è½ã§ãããã«ã¬ã³ãã¼ã®ä½æä¾2ããã覧ãã ããã ããã¯ã¹ã¿ã¤ãã®ã«ã¬ã³ãã¼ä½ææ¹æ³ã®ä¾ããããTop㸠A1ã»ã«ã«æ¥ä»ãå
¥åããã ãã§ãææ¯ã®ã«ã¬ã³ãã¼ãä½æãã¦ã¿ã¾ãããã ããã§èª¬æãã¦ããæ°å¼ã¯ã第1é±ã®æ¥ææ¥ãæ±ãã¦ãã¾ãã 横æ¹åã¸ã¯+1ã縦æ¹åã¯+7ã¨ãããã¨ã§ããã¯ã¹åã®ã«ã¬ã³ãã¼ãä½æã§ãã¾ãã 該å½ããªããæãã®æ¥ä»é¨åã¯IFé¢æ°ã§ã""ããè¿ããããªä»çµã¿ã§ãã A1ã»ã«ã«è¡¨ç¤ºããæã®æ¥ä»ãå
¥åãã¾ãã2006å¹´11æãªãã2006/11/1ãã¨1æ¥ã®æ¥ä»ã¨å
¥å
{{#tags}}- {{label}}
{{/tags}}