ããã«ã¡ã¯ã
æè¿ãåéãçµå¶ããŠãããåºåãã®ã·ããè¡šãæ¹åããŠããŸãã
ä»æ¥ã¯ããã®äžã®åºç€äžã®åºç€ïŒã«ã¬ã³ããŒç®¡çã«ãããæ¥ä»ã®èªåèšå®ã«ã€ããŠåå¿é²ããŸãã
ç¹ã«ææ«æ¥ãææ¡ããæã«ãã£ãŠã¯ãã以éã空çœã«ããâŠãªã©ã®èæ ®ãéèŠãªãã€ã³ãã«ãªã£ãŠããŸãâŠðŠ
â åäœç°å¢
OS: Windows 8.1ïŒ64ãããïŒ
Excel: 2013ïŒ32ãããïŒ
â å®æã€ã¡ãŒãž
ã«ã¬ã³ããŒæ å ±ã®ãã¹ã¿ãŒã·ãŒãã«ãŠãæå®ããã幎æã«å¿ããŠæ¥ä»ãèªåçã«è¡šç€ºããä»çµã¿ãšããŠããŸããæ¥ä»ã¯ãæ倧31æ¥åã確ä¿ããã ãæã«å¿ããŠã®åžå¹ã¯ã空çœã§åž³å°»ãåãããããã«ããŸããã
â åæ¥ã®èªåèšå®
ãŸãã¯æåãã®æ¥ä»ãèªåèšå®ããŸããããã¯ã¹ã¿ãŒãæ¥ïŒ1ãšç¢ºå®ããŠããŸãã®ã§ãæå®ããã幎æãš1æ¥ã®æ å ±ããDATEé¢æ°ã§æå®ããŸãã
å ããŠãã»ã«ã®æžåŒèšå®ãã§ãd "æ¥"ãæå®ã§ããïŒ
ãã ããããã ãšå¯Ÿè±¡å¹Žæãæå®ãããŠããªãå Žåã¯ããšã©ãŒã«ãªã£ãŠããŸããããæäœéã®ãã©ããŒåŠçãå ¥ããŠãããŸãã
â 2æ¥ç®ä»¥éã®èªåèšå®
2æ¥ç®ä»¥éã¯ã1ã€åã®æ¥ã«ã¡ã«æ°åã®ã1ãã足ãã ãã§ãïŒç¬ïŒ
2æ¥ç®ã®ã»ã«ã«ã¯ã次ã®ãšããèšå®ããŸããã
ããšã¯2æ¥ã«èšå®ããå 容ããªãŒããã£ã«ãããã§ããããããããšF34:F36ïŒå³ã®èµ€æ ïŒã¯ãŸã1æ¥ããã¹ã¿ãŒããã¡ãã£ãŠãŸãðŠ
äžèº«ãã©ããªã£ãŠããããšãããšãæå®ããã察象幎æã2021/2ãã®æ¬¡ã®æã2021/3ãã«ç§»ã£ãŠããŸã£ãŠããããšãåããŸãïŒãã»ã«ã®æžåŒèšå®ããã¡ããã£ãšå€æŽããŸããïŒðŠ
â ææ«æ¥ã®ç®¡ç
次ã®æã®æ¥ä»ã«ãªã£ãã衚瀺ããããããŸãããããŒâª
ããã§2æ¥ç®ä»¥éã¯ãæå®ããã察象幎æãšåããïŒæ¯åãã§ãã¯ããä»çµã¿ã«å€æŽããŸããïŒã»ããšã¯ææ«ã®åžå¹ãããåŸã29æ¥ä»¥éã®ã¿èæ ®ããã°è¯ãã®ã§ãããŒããèšå®ããåŒã®ããªãšãŒã·ã§ã³ãå¢ãããããªãã®ã§ã2æ¥ç®ä»¥éåæ§ã®åŒã«ããŸãïŒ
æ¥ä»æ å ±ã®ãã¡æã®ã¿ãç §åãããã®ã§ãMONTHé¢æ°ã䜿ããŸãã
2æ¥ç®ã®ã»ã«ã«ã¯ã次ã®ãšããèšå®ããŸããã
æ¬æ¥èšå®ããäºå®ã®åŒã$F6+1ãã®æéšåãã察象幎æã§æå®ãããæã$D$5ããšäžèŽããªãã£ãã空ã£ãœã«ããŸãïŒ
ããšã¯æåŸã®ã»ã«ãŸã§ãªãŒããã£ã«ãããšæ¬¡ã®ãšããã«ãªããŸãã
F35:F36ããšã©ãŒã«ãªã£ãŠããã®ã¯ãåã®æ¥ä»ïŒææ«æ¥ç®¡çã®åŒãåãå¥ããF34ã空ã£ãœã«ïŒïŒïŒãèŠå ã§ãã
ãããã1æ¥ç®ã«ãŠã察象幎æã空ã£ãœã ã£ããâŠãšããåŒãåã蟌ãã§ããŸãã®ã§ã2æ¥ç®ä»¥éãåã®æ¥ä»ã空ã£ãœã ã£ããâŠãšããããžãã¯ã§ããã¹ãã§ãã
ãã£ãŠãæçµçã«2æ¥ç®ä»¥éã¯æ¬¡ã®ãšãããšããŸããïŒ
ããšã¯æåŸã®ã»ã«ãŸã§ãªãŒããã£ã«ããšããŠãã ããã^^
â ãŸãšã
ãããã§ãããïŒ
ã·ããè¡šã§æãéèŠãªè»žãã«ã¬ã³ããŒã®ç®¡çã¯ãã®ãããªä»äžããŠããŸãã
æ¢ã«åå¿é²æžã®ç¥æ¥ç®¡çãšçµã¿åããããšãããªãã®ã«ã¬ã³ããŒãã¹ã¿ãŒãå®æããŸãâª