{"id":129,"date":"2023-11-15T13:41:10","date_gmt":"2023-11-15T13:41:10","guid":{"rendered":"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/"},"modified":"2023-12-11T06:59:34","modified_gmt":"2023-12-11T06:59:34","slug":"4%eb%b6%84%ec%9d%98-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/","title":{"rendered":"4\ubd84\uc758 1 \ub370\uc774\ud2b8\ub97c \uc5b4\ub5bb\uac8c \uad6c\ud558\ub098\uc694?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-81844449\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Excel\uc5d0\ub294 \ub0a0\uc9dc\uc5d0\uc11c \ubd84\uae30\ub97c \uac00\uc838\uc624\ub294 \uc9c1\uc811\uc801\uc778 \uae30\ub2a5\uc774 \uc5c6\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc774\uc5d0 \ub300\ud55c \uacf5\uc2dd\uc744 \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><p> \uc608, \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub0a0\uc9dc\ub85c\ubd80\ud130 \ubd84\uae30\ub97c \uacc4\uc0b0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc740 \uc5ec\ub7ec \uac00\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc88b\uc544\uc694, \uc544\uc2dc\ub2e4\uc2dc\ud53c 1\ub144\uc5d0 \ucd1d 4\uac1c\uc758 \ubd84\uae30\uac00 \uc788\uc9c0\ub9cc \uc0ac\uc2e4\uc740 \ub0a0\uc9dc\uc5d0\uc11c \ubd84\uae30\ub97c \ub2e4\ub978 \ubc29\uc2dd\uc73c\ub85c \uc5bb\uc744 \uc218 \uc788\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p><p> \uccab \ubc88\uc9f8\ub294 \uc77c\ubc18 \ub2ec\ub825 \uae30\uc900\uc73c\ub85c 1\ub144\uc744 \uac00\uc815\ud558\uace0 \ub450 \ubc88\uc9f8\ub294 \uc138\uae08 \ub2ec\ub825 \uae30\uc900\uc73c\ub85c \uac00\uc815\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc624\ub298 \uac8c\uc2dc\ubb3c\uc5d0\uc11c\ub294 \ub450 \uce98\ub9b0\ub354\ub97c \ubaa8\ub450 \uc0ac\uc6a9\ud558\uc5ec \ubd84\uae30 \ubc88\ud638\ub97c \uc5bb\ub294 \ubc29\ubc95\uc744 \ubcf4\uc5ec \ub4dc\ub9ac\uace0 \uc774\uc5d0 \ub300\ud55c \ub450 \uac00\uc9c0 \uc774\uc0c1\uc758 \ubc29\ubc95\ub3c4 \uacf5\uc720\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p><p> \uc774\uc81c \uc2dc\uc791\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p><h2 id=\"0-1-get-quarter-by-using-roundup-and-month-functions\" class=\"wp-block-heading\"> 1. ROUNDUP \ubc0f MONTH \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubd84\uae30 \uac00\uc838\uc624\uae30<\/h2><p> ROUNDUP\uacfc MONTH\uc758 \uc870\ud569\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \ub0a0\uc9dc\uc758 \ubd84\uae30\ub97c \ucc3e\ub294 \uac00\uc7a5 \uc88b\uc740 \ubc29\ubc95\uc785\ub2c8\ub2e4. 1\/4\uc744 \uc22b\uc790(\uc608: 1,2,3,4)\ub85c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p><p> \uacf5\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=ROUNDUP(MONTH(A1)\/3,0)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png\" sizes=\"\" srcset=\"\" alt=\"\ub465\uadfc \ub2ec \uacf5\uc2dd\uc744 \uc0ac\uc6a9\ud558\ub294 Excel \ubd84\uae30 \ubc88\ud638\"><\/figure><\/div><p> \uc5ec\uae30\uc11c\ub294 2018\ub144 5\uc6d4 26\uc77c\uc744 \ub0a0\uc9dc\ub85c \uc0ac\uc6a9\ud558\uace0 \uc218\uc2dd\uc740 \uacb0\uacfc\uc5d0 2\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4. \ubd84\uae30 \ubc88\ud638 \uc55e\uc5d0 Q\ub97c \ucd94\uac00\ud558\ub824\uba74 \uc544\ub798 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=\"Q-\"&amp;ROUNDUP(MONTH(A1)\/3,0)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" class=\"wp-image-22413\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-avec-q.png\" sizes=\"\" srcset=\"\" alt=\"q\uc640 \ud568\uaed8 \ub465\uadfc \ub2ec \uacf5\uc2dd\uc744 \uc0ac\uc6a9\ud558\ub294 Excel \ubd84\uae30 \uc218\"><\/figure><\/div><h3 id=\"1-how-this-formula-works-\" class=\"wp-block-heading\"> <strong>\uc774 \uacf5\uc2dd\uc740 \uc5b4\ub5bb\uac8c \uc791\ub3d9\ud558\ub098\uc694?<\/strong><\/h3><p> \uc774 \uacf5\uc2dd\uc740 \uc138 \ubd80\ubd84\uc73c\ub85c \uad6c\uc131\ub429\ub2c8\ub2e4.<\/p><p> <strong>\uccab \ubc88\uc9f8<\/strong> \ubd80\ubd84\uc5d0\uc11c\ub294 MONTH \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uace0 \uc6d4 \ubc88\ud638\ub97c \ubc18\ud658\ud558\ub294 \ub0a0\uc9dc\ub97c \ucc38\uc870\ud588\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-utilisant-la-formule-du-mois-rond-premiere-partie-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> \uadf8 \ud6c4 <strong>\ub450 \ubc88\uc9f8<\/strong> \ubd80\ubd84\uc5d0\uc11c\ub294 \uc774\ubc88 \ub2ec \uc22b\uc790\ub97c 3\uc73c\ub85c \ub098\ub204\uc5b4 \uc18c\uc218\uc810 \uc774\ud558 \uc790\ub9bf\uc218\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-partie-seconde-1.png\" sizes=\"\" srcset=\"\" alt=\"\ub465\uadfc \uc6d4 \uc218\uc2dd \ub450 \ubc88\uc9f8 \ubd80\ubd84\uc744 \uc0ac\uc6a9\ud558\uc5ec Excel \ubd84\uae30 \ubc88\ud638\"><\/figure><\/div><p> \ub9c8\uc9c0\ub9c9\uc73c\ub85c <strong>\uc138 \ubc88\uc9f8<\/strong> \ubd80\ubd84\uc5d0\uc11c\ub294 ROUNDUP \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc774 \uc22b\uc790\ub97c \uc18c\uc218\uc810 \uc774\ud558 \uc790\ub9bf\uc218\ub85c \ubc18\uc62c\ub9bc\ud558\uc5ec \uc2e4\uc81c \ubd84\uae30\ub97c \uc81c\uacf5\ud588\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-utilisant-la-formule-du-mois-rond-troisieme-partie.png\" sizes=\"\" srcset=\"\" alt=\"\ubc18\ub2ec \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec Excel \ubd84\uae30 \ubc88\ud638 3\ubd80\"><\/figure><\/div><p> \uc2e4\uc81c \ub0b4\uc6a9\uc740 <strong>\ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4<\/strong> . 4\ubd84\uae30\uc640 12\uac1c\uc6d4\uc774 \uc788\ub2e4\ub294 \uac83\uc744 \uc54c\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc624\ub978\ucabd? \uadf8\ub9ac\uace0 \ubaa8\ub4e0 \uc6d4 \uc22b\uc790\ub97c 3\uc73c\ub85c \ub098\ub204\uba74(\uc608, 3\uc73c\ub85c\ub9cc) \uc544\ub798\uc640 \uac19\uc740 \uacb0\uacfc\uac00 \ub098\uc635\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/bases-de-la-formule-de-numero-de-trimestre-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"\uc5d1\uc140 \ubd84\uae30 \uc22b\uc790 \uacf5\uc2dd\uc758 \uae30\ubcf8\"><\/figure><\/div><p> \uadf8\ub9ac\uace0 \ubc18\uc62c\ub9bc\ud558\uba74 \ud56d\uc0c1 \ud574\ub2f9 \uc6d4\uc758 \ubd84\uae30 \ubc88\ud638\ub97c \uc5bb\uac8c \ub429\ub2c8\ub2e4.<\/p><h2 id=\"2-2-get-quarter-by-using-fiscal-calendar\" class=\"wp-block-heading\"> 2. \ud68c\uacc4 \ub2ec\ub825\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubd84\uae30 \uac00\uc838\uc624\uae30<\/h2><p> \uc704\uc758 \uc608\uc5d0\uc11c\ub294 \ub0a0\uc9dc\ub85c\ubd80\ud130 \ubd84\uae30\ub97c \uacc4\uc0b0\ud558\uae30 \uc704\ud574 \uac04\ub2e8\ud55c \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud588\uc9c0\ub9cc \ud68c\uacc4 \ub2ec\ub825\uc744 \uc0ac\uc6a9\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p><div class=\"wp-block-group is-layout-flow\"><div class=\"wp-block-group__inner-container\"><p> <em>\ud68c\uacc4\uc5f0\ub3c4\ub780 \ubb34\uc5c7\uc785\ub2c8\uae4c?<\/em><\/p><p> <em>\ud68c\uacc4\uc5f0\ub3c4(FY)\ub294 \uae30\uc5c5\uc774\ub098 \uc815\ubd80\uac00 \ud68c\uacc4 \ubaa9\uc801\uacfc \uc7ac\ubb34\uc81c\ud45c \uc791\uc131\uc744 \uc704\ud574 \uc0ac\uc6a9\ud558\ub294 12\uac1c\uc6d4 \uae30\uac04\uc785\ub2c8\ub2e4. \ud68c\uacc4 \uc5f0\ub3c4\ub294 \ub2ec\ub825 \uc5f0\ub3c4\uc640 \uc77c\uce58\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4\u2026<\/em><\/p><p> <em><a href=\"https:\/\/www.investopedia.com\/terms\/f\/fiscalyear.asp\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">\u2026\ub354 \uc54c\uc544\ubcf4\uae30<\/a><\/em><\/p><\/div><\/div><p> \uadf8\ub9ac\uace0 \ud68c\uacc4 \ub2ec\ub825 \ubd84\uae30 \uacc4\uc0b0\uc744 \uc704\ud574\uc11c\ub294 \ub2e4\ub978 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud574\uc57c \ud558\uba70 \uc774 \uc218\uc2dd\uc5d0\uc11c\ub294 SELECT \ubc0f MONTH \ud568\uc218\ub97c \uacb0\ud569\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p><p> \uacf5\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=CHOOSE(MONTH(A1),4,4,4,1,1,1,2,2,2,3,3,3)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22418\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-a-laide-de-la-formule-de-lannee-fiscale.png\" sizes=\"auto, \" srcset=\"\" alt=\"\ud68c\uacc4 \uc5f0\ub3c4 \uacf5\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec Excel \ubd84\uae30 \ubc88\ud638\" width=\"576\" height=\"168\"><\/figure><\/div><p> (\uc5ec\uae30\uc5d0\uc11c\ub294 4\uc6d4 1\uc77c\uc5d0 \uc2dc\uc791\ud558\uc5ec 3\uc6d4 31\uc77c\uc5d0 \ub05d\ub098\ub294 \uc778\ub3c4 \ud68c\uacc4\uc5f0\ub3c4\ub97c \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4.)<\/p><p> \ub2ec\uc774 5\uc6d4\uc774\uace0 \uc5f0\ub3c4\uac00 4\uc6d4\ubd80\ud130 \uc2dc\uc791\ud558\uace0 5\uc6d4\uc774 1\ubd84\uae30\uc5d0 \ud574\ub2f9\ud558\ub294 \uc5f0\ub3c4\uc758 \ub450 \ubc88\uc9f8 \ub2ec\uc774\uae30 \ub54c\ubb38\uc5d0 \uacb0\uacfc\uc5d0 1\uc774 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/p><h3 id=\"how-this-formula-works\" class=\"wp-block-heading\"> <strong>\uc774 \uacf5\uc2dd\uc740 \uc5b4\ub5bb\uac8c \uc791\ub3d9\ud558\ub098\uc694?<\/strong><\/h3><p> \uc5ec\uae30\uc11c \uc6b0\ub9ac\ub294 \ub450 \uac00\uc9c0 \ub2e4\ub978 \uae30\ub2a5\uc744 \uacb0\ud569\ud588\uc73c\uba70 \ub450 \ubd80\ubd84\uc73c\ub85c \uc791\ub3d9\ud569\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-a-laide-de-la-formule-de-lannee-fiscale.png\" sizes=\"\" srcset=\"\" alt=\"\ud68c\uacc4 \uc5f0\ub3c4 \uacf5\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec Excel \ubd84\uae30 \ubc88\ud638\uac00 \uc791\ub3d9\ud569\ub2c8\ub2e4.\"><\/figure><\/div><p> <strong>\uccab \ubc88\uc9f8<\/strong> \ubd80\ubd84\uc5d0\uc11c\ub294 MONTH \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub0a0\uc9dc\uc5d0\uc11c \uc6d4 \ubc88\ud638\ub97c \uac00\uc838\uc654\uace0 \uc5ec\uae30\uc11c\ub294 5\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-utilisant-la-premiere-partie-de-la-formule-de-lexercice-avec-la-fonction-du-mois.png\" sizes=\"\" srcset=\"\" alt=\"\uc6d4 \ud568\uc218\uc640 \ud568\uaed8 \ud68c\uacc4\uc5f0\ub3c4 \uacf5\uc2dd\uc758 \uccab \ubc88\uc9f8 \ubd80\ubd84\uc744 \uc0ac\uc6a9\ud558\ub294 Excel \ubd84\uae30 \ubc88\ud638\"><\/figure><\/div><p> \uadf8 \ud6c4 <strong>\ub450 \ubc88\uc9f8<\/strong> \ubd80\ubd84\uc5d0\uc11c\ub294 MONTH \ud568\uc218\uc5d0\uc11c \ubc18\ud658\ub41c \uc6d4 \uc22b\uc790\ub97c \uae30\ubc18\uc73c\ub85c \uc22b\uc790\ub97c \uac00\uc838\uc624\ub294 \ud568\uc218\ub97c \uc120\ud0dd\ud588\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-de-lexercice-fiscal-deuxieme-partie-choisir.png\" sizes=\"\" srcset=\"\" alt=\"\ud68c\uacc4 \uc5f0\ub3c4 \uacf5\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec Excel \ubd84\uae30 \ubc88\ud638 \ub450 \ubc88\uc9f8 \ubd80\ubd84 \uc120\ud0dd\"><\/figure><\/div><p> \uc5ec\uae30\uc5d0\uc11c CHOOSE\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p><p> \ubcf4\uc2dc\uba74 CHOOSE \ud568\uc218\uc5d0\uc11c 12\uac1c\uc758 \uc11c\ub85c \ub2e4\ub978 \uc22b\uc790(4,4,4,1,1,1,2,2,2,3,3,3)\ub97c \uc9c0\uc815\ud588\uc73c\ubbc0\ub85c MONTH\uac00 \uc22b\uc790\ub97c \ubc18\ud658\ud558\uba74 CHOOSE\ub294 \uc22b\uc790\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4. \uadf8\uac83\uc758 \ubaa9\ub85d.<\/p><p> \uac70\ub798\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p><p> \ucc98\uc74c \uc138 \uc790\ub9ac \uc22b\uc790\uc5d0\ub294 4\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc989, 1, 2 \ub610\ub294 3(1\uc6d4~3\uc6d4)\uc744 \ubc18\ud658\ud558\uba74 4\ub97c \uc5bb\uac8c \ub418\uace0 \ub2e4\uc74c 3\uac1c\uc6d4 \ub3d9\uc548\uc740 1\uc744 \uc5bb\uac8c \ub429\ub2c8\ub2e4(\uc5f0\ub3c4 \uc138\uae08\uc774 4\uc6d4\ubd80\ud130 \uc2dc\uc791\ub418\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4).<\/p><h2 id=\"3-3-convert-a-date-into-a-quarter-using-vba-code\" class=\"wp-block-heading\"> 3. VBA \ucf54\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub0a0\uc9dc\ub97c \ubd84\uae30\ub85c \ubcc0\ud658<\/h2><p> \uc5ec\uae30\uc11c\ub294 VBA \ucf54\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub0a0\uc9dc\ub97c \ubd84\uae30 \uc22b\uc790\ub85c \uac04\ub2e8\ud788 \ubcc0\ud658\ud569\ub2c8\ub2e4. \ucf54\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub convert2Quarter() Dim Rng As Range For Each Rng In Selection If IsDate(Rng.Value) = True Then Rng.Value = DatePart(\"q\", Rng.Value) Rng.NumberFormat = \u201cGeneral\u201d End If Next Rng End Sub<\/code><\/pre><p> \uc774 \ucf54\ub4dc\ub97c \uc0ac\uc6a9\ud558\ub824\uba74 VB \ud3b8\uc9d1\uae30\uc5d0 \ucd94\uac00\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/code-vba-pour-obtenir-le-numero-de-trimestre-excel-vbe.png\" sizes=\"\" srcset=\"\" alt=\"\ubd84\uae30 \ubc88\ud638\ub97c \uc5bb\ub294 \ucf54\ub4dc Excel VBE\"><\/figure><\/div><p> \uadf8\ub7f0 \ub2e4\uc74c \ub0a0\uc9dc\ub97c \ubd84\uae30 \uc22b\uc790\ub85c \ubcc0\ud658\ud574\uc57c \ud558\ub294 \uc140\uc744 \uc120\ud0dd\ud558\uace0 \ub9c8\uc9c0\ub9c9\uc73c\ub85c \uc774 \ucf54\ub4dc\ub97c \uc2e4\ud589\ud558\uc138\uc694.<\/p><h3 id=\"here-s-how-this-code-works\" class=\"wp-block-heading\"> \uc774 \ucf54\ub4dc\uc758 \uc791\ub3d9 \ubc29\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/h3><p> \uc774 \ucf54\ub4dc\ub97c \uc2e4\ud589\ud558\uba74 \uba3c\uc800 \uc140\uc5d0 \ub0a0\uc9dc\uac00 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uace0, \ub0a0\uc9dc\uc774\uba74 \ubd84\uae30 \uc22b\uc790\ub85c \ubcc0\ud658\ud569\ub2c8\ub2e4.<\/p><p> \uc5ec\uae30\uc11c\ub294 \ub450 \uac00\uc9c0 VBA \ud568\uc218\ub97c \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4.<\/p><ol><li> ISDATE: \uc140\uc5d0 \ub0a0\uc9dc\uac00 \uc788\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/li><li> DATEPART: \ub0a0\uc9dc\ub97c \ubd84\uae30\ub85c \ubcc0\ud658\ud569\ub2c8\ub2e4.<\/li><\/ol><p> <strong>\ub2e4\uc74c\uc744 \ud655\uc778\ud558\uc138\uc694: VBA \ucd08\ubcf4\uc790\ub97c \uc704\ud55c \uc720\uc6a9\ud55c \uc0c1\uc704 100\uac1c \ub9e4\ud06c\ub85c \ucf54\ub4dc | <a href=\"https:\/\/exceladvisor.org\/ko\/vba\/\">Excel\uc758 VBA \ub780 \ubb34\uc5c7\uc785\ub2c8\uae4c?<\/a><\/strong><\/p><h2 id=\"4-4-get-quarter-start-date-from-a-date\" class=\"wp-block-heading\"> 4. \ub0a0\uc9dc\uc5d0\uc11c \ubd84\uae30 \uc2dc\uc791\uc77c \uac00\uc838\uc624\uae30<\/h2><p> \ubd84\uae30 \ubc88\ud638\ub294 \uc78a\uc5b4\ubc84\ub9ac\uace0 \ubd84\uae30 \uc2dc\uc791\uc77c\uc744 \uc0ac\uc6a9\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p><p> \uc989, \ub0a0\uc9dc\uac00 2018\ub144 5\uc6d4 26\uc77c\uc778 \uacbd\uc6b0 \ubd84\uae30 \ubc88\ud638 2 \ub300\uc2e0 2018\ub144 4\uc6d4 1\uc77c\uc744 \ud574\ub2f9 \ubd84\uae30\uc758 \uccab \ubc88\uc9f8 \ub2ec\uc758 \uc2dc\uc791\uc77c\ub85c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc6b0\ub9ac\uac00 \uc0ac\uc6a9\ud574\uc57c \ud558\ub294 \uacf5\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATE(YEAR(A1),FLOOR.MATH(\u200bMONTH (A1)-1,3)+1,1)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22429\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-de-date-de-debut-de-trimestre-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"\ubd84\uae30 \uc2dc\uc791\uc77c \uc218\uc2dd \uc5d1\uc140\" width=\"619\" height=\"143\"><\/figure><\/div><p> \uc774 \uc218\uc2dd\uc744 \uc785\ub825\ud558\uba74 \ud574\ub2f9 \ubd84\uae30\uc758 \uc2dc\uc791 \ub0a0\uc9dc\ub9cc \ubc18\ud658\ub429\ub2c8\ub2e4.<\/p><h3 id=\"how-this-formula-works\" class=\"wp-block-heading\"> <strong>\uc774 \uacf5\uc2dd\uc740 \uc5b4\ub5bb\uac8c \uc791\ub3d9\ud558\ub098\uc694?<\/strong><\/h3><p> \uc774 \uacf5\uc2dd\uc740 \ud559\uae30\uac00 \uc2dc\uc791\ub418\ub294 \ub0a0\uc9dc\ub97c \uc54c\ub824\uc8fc\ub294 \ub124 \uac00\uc9c0 \ubd80\ubd84\uc73c\ub85c \uad6c\uc131\ub429\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-de-date-de-debut-de-trimestre-excel.png\" sizes=\"\" srcset=\"\" alt=\"\ubd84\uae30 \uc2dc\uc791\uc77c \uc218\uc2dd\uc740 Excel\uc5d0\uc11c \uc791\ub3d9\ud569\ub2c8\ub2e4.\"><\/figure><\/div><p> <strong>\uccab \ubc88\uc9f8<\/strong> \ubd80\ubd84\uc5d0\uc11c\ub294 \ub0a0\uc9dc\uc758 \uc6d4 \uc218\ub97c \ubc18\ud658\ud558\ub294 MONTH \ud568\uc218\ub97c \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-de-date-de-debut-de-trimestre-excel.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> \ub530\ub77c\uc11c MONTH\uac00 \uc6d4 \ubc88\ud638\ub85c 5\ub97c \ubc18\ud658\ud558\uba74(\uadf8 \uc911 1\uc744 \ube80 \uac12) <strong>\ub450 \ubc88\uc9f8<\/strong> \ubd80\ubd84\uc5d0\uc11c FLOOR\ub294 \uc774\ub97c 3\uc73c\ub85c \ubc18\uc62c\ub9bc\ud55c \ub2e4\uc74c 1\uc744 \ub354\ud558\uc5ec \uac19\uc740 \ubd84\uae30\uc758 \uccab \ubc88\uc9f8 \ub2ec(4\uc6d4)\uc778 4\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\uae4c? <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-trimestre-date-de-debut-formule-etage-maths.png\" sizes=\"\" srcset=\"\" alt=\"Excel \ubd84\uae30 \uc2dc\uc791\uc77c \uacf5\uc2dd \ubc14\ub2e5 \uc218\ud559\"><\/figure><\/div><p> \uadf8 \ud6c4 <strong>\uc138 \ubc88\uc9f8<\/strong> \ubd80\ubd84\uc5d0\uc11c\ub294 YEAR \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2e4\uc81c \ub0a0\uc9dc\uc5d0\uc11c \uc5f0\ub3c4\ub97c \uac00\uc838\uc654\uc2b5\ub2c8\ub2e4.<\/p><p> \uadf8\ub9ac\uace0 <strong>\ub124 \ubc88\uc9f8<\/strong> \ubd80\ubd84\uc5d0\uc11c\ub294 \uac04\ub2e8\ud788 DATE \ud568\uc218\ub97c \uacb0\ud569\ud558\uc5ec \ucc98\uc74c \ub450 \ubd80\ubd84\uc758 \uac12\uc744 \uacb0\ud569\ud55c \ub0a0\uc9dc\ub97c \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4.<\/p><h2 id=\"5-5-get-quarter-end-date-from-a-date\" class=\"wp-block-heading\"> 5. \ub0a0\uc9dc\uc5d0\uc11c \ubd84\uae30 \uc885\ub8cc\uc77c \uac00\uc838\uc624\uae30<\/h2><p> \uc88b\uc2b5\ub2c8\ub2e4. \uc2dc\uc791 \ub0a0\uc9dc\ub098 \uc22b\uc790 \ub300\uc2e0 \ubd84\uae30 \uc885\ub8cc \ub0a0\uc9dc\uac00 \ud544\uc694\ud558\uba70 \uc774\ub97c \uc704\ud574 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uacf5\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATE(YEAR(A2),((INT((MONTH(A2)-1)\/3)+1)*3)+1,1)-1<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-22300\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-trimestrielle-excel-obtenir-la-date-de-fin.png\" sizes=\"auto, \" srcset=\"\" alt=\"\ubd84\uae30\ubcc4 \uc218\uc2dd Excel \uc885\ub8cc \ub0a0\uc9dc \uac00\uc838\uc624\uae30\" width=\"618\" height=\"134\"><\/figure><\/div><p> 2018\ub144 5\uc6d4 26\uc77c\uc758 \uacbd\uc6b0 \ud574\ub2f9 \ubd84\uae30\uc758 \ub9c8\uc9c0\ub9c9 \ub0a0\uc9dc\uc778 2018\ub144 6\uc6d4 30\uc77c\uc5d0 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/p><h3 id=\"how-this-formula-works\" class=\"wp-block-heading\"> <strong>\uc774 \uacf5\uc2dd\uc740 \uc5b4\ub5bb\uac8c \uc791\ub3d9\ud558\ub098\uc694?<\/strong><\/h3><p> \uc774 \uacf5\uc2dd\uc5d0\ub294 \ub124 \uac00\uc9c0 \ub2e4\ub978 \ubd80\ubd84\uc774 \uc788\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-trimestrielle-excel-obtenir-la-date-de-fin.png\" sizes=\"\" srcset=\"\" alt=\"\ubd84\uae30\ubcc4 \uacf5\uc2dd Excel \uc885\ub8cc \ub0a0\uc9dc \uac00\uc838\uc624\uae30\uac00 \uc791\ub3d9\ud569\ub2c8\ub2e4.\"><\/figure><\/div><p> <strong>\uccab \ubc88\uc9f8<\/strong> \ubd80\ubd84\uc5d0\uc11c\ub294 INT \ubc0f MONTH \ud568\uc218\ub97c \uacb0\ud569\ud588\uc2b5\ub2c8\ub2e4. MONTH\ub294 \ub0a0\uc9dc\uc758 \uc6d4 \uc218\ub97c \ubc18\ud658\ud55c \ub2e4\uc74c \uc774\ub97c 3\uc73c\ub85c \ub098\ub215\ub2c8\ub2e4. \uadf8 \ud6c4 INT\ub294 \uc774\ub97c \uac00\uc7a5 \uac00\uae4c\uc6b4 \uc815\uc218\ub85c \ubc18\uc62c\ub9bc\ud569\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-trimestrielle-excel-obtenir-la-date-de-fin-premiere-partie.png\" sizes=\"\" srcset=\"\" alt=\"\ubd84\uae30\ubcc4 \uc218\uc2dd Excel \uc885\ub8cc\uc77c \uac00\uc838\uc624\uae30 \uccab \ubc88\uc9f8 \ubd80\ubd84\"><\/figure><\/div><p> \uacb0\uad6d 3\uc744 \uacf1\ud558\uc5ec \ubd84\uae30\uc758 \ub9c8\uc9c0\ub9c9 \ub2ec\uc778 6(6\uc6d4)\uc744 \uad6c\ud558\uace0 \uc5ec\uae30\uc5d0 1\uc744 \ub354\ud569\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-trimestrielle-excel-obtenir-la-date-de-fin-premiere-partie.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> \uac04\ub2e8\ud788 \ub9d0\ud574\uc11c, \uc218\uc2dd\uc758 \uc774 \ubd80\ubd84\uc740 \ub2e8\uc21c\ud788 \uc2e4\uc81c \ub0a0\uc9dc\uc758 \uc6d4\uc744 \ub2e4\uc74c \ubd84\uae30\uc758 \uccab \ubc88\uc9f8 \ub2ec\ub85c \ubcc0\ud658\ud569\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-trimestrielle-excel-obtenir-la-date-de-fin-premiere-partie-plus-un.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> <strong>\ub450 \ubc88\uc9f8<\/strong> \ubd80\ubd84\uc5d0\uc11c\ub294 YEAR \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2e4\uc81c \ub0a0\uc9dc\uc5d0\uc11c \uc5f0\ub3c4\ub97c \uac00\uc838\uc654\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-trimestrielle-excel-obtenir-la-date-de-fin-deuxieme-partie.png\" sizes=\"\" srcset=\"\" alt=\"\ubd84\uae30\ubcc4 \uc218\uc2dd Excel \uc885\ub8cc \ub0a0\uc9dc \uac00\uc838\uc624\uae30 2\ubd80\"><\/figure><\/div><p> \uadf8 \ud6c4 <strong>\uc138 \ubc88\uc9f8<\/strong> \ubd80\ubd84\uc5d0\uc11c\ub294 1\uc744 \uc0ac\uc6a9\ud558\uc5ec DATE \ud568\uc218\ub85c \ub0a0\uc9dc\ub97c \uc644\uc131\ud569\ub2c8\ub2e4.<\/p><p> \uc8c4\uc1a1\ud569\ub2c8\ub2e4! \ud558\ub098 \ub354.<\/p><p> <strong>\ub124 \ubc88\uc9f8<\/strong> \uc5d0\uc11c\ub294 \uc804\uccb4 \uc218\uc2dd\uc5d0\uc11c 1\uc744 \ube7c\ubbc0\ub85c \ub2e4\uc74c \ubd84\uae30\uc758 \uccab \ubc88\uc9f8 \ub0a0\uc9dc \ub300\uc2e0 \ud574\ub2f9 \ubd84\uae30\uc758 \ub9c8\uc9c0\ub9c9 \ub0a0\uc9dc\ub97c \uac00\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-trimestrielle-excel-obtenir-la-date-de-fin-troisieme-partie.png\" sizes=\"\" srcset=\"\" alt=\"\ubd84\uae30\ubcc4 \uc218\uc2dd Excel \uc885\ub8cc\uc77c \uac00\uc838\uc624\uae30 3\ubd80\"><\/figure><\/div><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> \uc5d1\uc140 \ud30c\uc77c \ubc1b\uae30<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/quart-formule-2.xlsx\" rel=\"nofollow\">\ub2e4\uc6b4\ub85c\ub4dc<\/a><\/p><\/div><h2 id=\"7-conclusion\" class=\"wp-block-heading\"> \uacb0\ub860<\/h2><p> \ub2e8\uc21c\ud788 \ud568\uc218\ub97c \uacb0\ud569\ud558\uba74 \ub0a0\uc9dc\ub85c\ubd80\ud130 \ubd84\uae30\ub97c \uacc4\uc0b0\ud558\ub294 \uac04\ub2e8\ud55c \uc218\uc2dd\uc744 \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc774 \uae30\uc0ac\uc5d0\uc11c\ub294 \uc774\uc5d0 \ub300\ud55c \ub124 \uac00\uc9c0 \uc218\uc2dd + VBA \ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4.<\/p><p> \uc194\uc9c1\ud788 #1\uc740 \ubd84\uae30 \ub0a0\uc9dc\ub97c \ucc3e\ub294 \uac00\uc7a5 \ub9ce\uc774 \uc0ac\uc6a9\ub418\uace0 \uac00\uc7a5 \uc26c\uc6b4 \ubc29\ubc95\uc774\uc9c0\ub9cc \uc6d0\ud560 \uacbd\uc6b0 \ub098\uba38\uc9c0\ub3c4 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uae30\uc0ac\uac00 \ub3c4\uc6c0\uc774 \ub418\uc5c8\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4. \uc774\uc81c \uc774 \ub0b4\uc6a9\uc744 \uc54c\ub824\uc8fc\uc138\uc694.<\/p><p> <em>\ub0a0\uc9dc\uc5d0\uc11c \ubd84\uae30 \uc218\ub97c \uacc4\uc0b0\ud558\ub294 \ub2e4\ub978 \ubc29\ubc95\uc744 \uc54c\uace0 \uc788\uc2b5\ub2c8\uae4c?<\/em><\/p><p> \ub313\uae00 \uc139\uc158\uc5d0\uc11c \uc800\uc640 \uacf5\uc720\ud574 \uc8fc\uc138\uc694. \uc5ec\ub7ec\ubd84\uc758 \uc758\uacac\uc744 \ub4e3\uace0 \uc2f6\uc2b5\ub2c8\ub2e4. \uc774 \ud301\uc744 \uce5c\uad6c\ub4e4\uacfc \uacf5\uc720\ud558\ub294 \uac83\ub3c4 \uc78a\uc9c0 \ub9c8\uc138\uc694. \ub098\ub294 \uadf8\ub4e4\uc774 \uadf8\uac83\uc744 \uace0\ub9d9\uac8c \uc5ec\uae38 \uac83\uc774\ub77c\uace0 \ud655\uc2e0\ud569\ub2c8\ub2e4.<\/p><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> Excel \uc218\uc2dd \ubaa9\ub85d<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \uad00\ub828 \uc218\uc2dd <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> Excel\uc5d0\uc11c \ub0a0\uc9dc\uc5d0 \ud55c \ub2ec \ucd94\uac00<\/li><li> Excel\uc5d0\uc11c \uc6d4\uc758 \uc885\ub8cc \ub0a0\uc9dc\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li><li> Excel\uc5d0\uc11c \uc6d4\uc758 \uccab\ub0a0 \uac00\uc838\uc624\uae30(\uc6d4 \uc2dc\uc791)<\/li><li> Excel\uc5d0\uc11c \ub0a0\uc9dc\ub85c\ubd80\ud130 \uc6d4 \uad6c\ud558\uae30(\ubc1c\ucdcc) <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-129","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel\uc5d0\uc11c \ub0a0\uc9dc\uc758 \ubd84\uae30\ub97c \uc5bb\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?<\/title>\n<meta name=\"description\" content=\"\uc5ec\uae30\uc5d0\ub294 \ub370\uc774\ud2b8\uc5d0\uc11c 1\/4\uc744 \uc5bb\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc0c1\uc704 5\uac00\uc9c0 \ubc29\ubc95\uc774 \ub098\uc5f4\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub4e4 \ubc29\ubc95\uc740 \uac01\uac01\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/ko\/4\ubd84\uc758-1\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel\uc5d0\uc11c \ub0a0\uc9dc\uc758 \ubd84\uae30\ub97c \uc5bb\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?\" \/>\n<meta property=\"og:description\" content=\"\uc5ec\uae30\uc5d0\ub294 \ub370\uc774\ud2b8\uc5d0\uc11c 1\/4\uc744 \uc5bb\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc0c1\uc704 5\uac00\uc9c0 \ubc29\ubc95\uc774 \ub098\uc5f4\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub4e4 \ubc29\ubc95\uc740 \uac01\uac01\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/ko\/4\ubd84\uc758-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-11T06:59:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/\",\"url\":\"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/\",\"name\":\"Excel\uc5d0\uc11c \ub0a0\uc9dc\uc758 \ubd84\uae30\ub97c \uc5bb\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png\",\"datePublished\":\"2023-11-15T13:41:10+00:00\",\"dateModified\":\"2023-12-11T06:59:34+00:00\",\"description\":\"\uc5ec\uae30\uc5d0\ub294 \ub370\uc774\ud2b8\uc5d0\uc11c 1\/4\uc744 \uc5bb\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc0c1\uc704 5\uac00\uc9c0 \ubc29\ubc95\uc774 \ub098\uc5f4\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub4e4 \ubc29\ubc95\uc740 \uac01\uac01\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\uc9d1\",\"item\":\"https:\/\/exceladvisor.org\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"4\ubd84\uc758 1 \ub370\uc774\ud2b8\ub97c \uc5b4\ub5bb\uac8c \uad6c\ud558\ub098\uc694?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#website\",\"url\":\"https:\/\/exceladvisor.org\/ko\/\",\"name\":\"Excel Advisor\",\"description\":\"\ub370\uc774\ud130 \uc9c0\ubc30\ub825\uc744 \uc704\ud55c \uac00\uc774\ub4dc!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/ko\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/ko\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel\uc5d0\uc11c \ub0a0\uc9dc\uc758 \ubd84\uae30\ub97c \uc5bb\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?","description":"\uc5ec\uae30\uc5d0\ub294 \ub370\uc774\ud2b8\uc5d0\uc11c 1\/4\uc744 \uc5bb\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc0c1\uc704 5\uac00\uc9c0 \ubc29\ubc95\uc774 \ub098\uc5f4\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub4e4 \ubc29\ubc95\uc740 \uac01\uac01","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/ko\/4\ubd84\uc758-1\/","og_locale":"ko_KR","og_type":"article","og_title":"Excel\uc5d0\uc11c \ub0a0\uc9dc\uc758 \ubd84\uae30\ub97c \uc5bb\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?","og_description":"\uc5ec\uae30\uc5d0\ub294 \ub370\uc774\ud2b8\uc5d0\uc11c 1\/4\uc744 \uc5bb\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc0c1\uc704 5\uac00\uc9c0 \ubc29\ubc95\uc774 \ub098\uc5f4\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub4e4 \ubc29\ubc95\uc740 \uac01\uac01","og_url":"https:\/\/exceladvisor.org\/ko\/4\ubd84\uc758-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-11T06:59:34+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/","url":"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/","name":"Excel\uc5d0\uc11c \ub0a0\uc9dc\uc758 \ubd84\uae30\ub97c \uc5bb\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png","datePublished":"2023-11-15T13:41:10+00:00","dateModified":"2023-12-11T06:59:34+00:00","description":"\uc5ec\uae30\uc5d0\ub294 \ub370\uc774\ud2b8\uc5d0\uc11c 1\/4\uc744 \uc5bb\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc0c1\uc704 5\uac00\uc9c0 \ubc29\ubc95\uc774 \ub098\uc5f4\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub4e4 \ubc29\ubc95\uc740 \uac01\uac01","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/numero-de-trimestre-excel-en-utilisant-la-formule-du-mois-rond-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/ko\/4%eb%b6%84%ec%9d%98-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\uc9d1","item":"https:\/\/exceladvisor.org\/ko\/"},{"@type":"ListItem","position":2,"name":"4\ubd84\uc758 1 \ub370\uc774\ud2b8\ub97c \uc5b4\ub5bb\uac8c \uad6c\ud558\ub098\uc694?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/ko\/#website","url":"https:\/\/exceladvisor.org\/ko\/","name":"Excel Advisor","description":"\ub370\uc774\ud130 \uc9c0\ubc30\ub825\uc744 \uc704\ud55c \uac00\uc774\ub4dc!","publisher":{"@id":"https:\/\/exceladvisor.org\/ko\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/ko\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/ko\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/ko\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/ko\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/comments?post=129"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/129\/revisions"}],"predecessor-version":[{"id":765,"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/pages\/129\/revisions\/765"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/ko\/wp-json\/wp\/v2\/media?parent=129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}