{"id":234,"date":"2025-05-25T21:59:44","date_gmt":"2025-05-25T12:59:44","guid":{"rendered":"https:\/\/cg-method.com\/google\/?p=234"},"modified":"2025-05-26T14:30:54","modified_gmt":"2025-05-26T05:30:54","slug":"google-sheets-businessdays-progress","status":"publish","type":"post","link":"https:\/\/cg-method.com\/google\/google-sheets-businessdays-progress\/","title":{"rendered":"Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u2502\u55b6\u696d\u65e5\u6570\u3068\u7d4c\u904e\u55b6\u696d\u65e5\u6570\u306e\u7b97\u51fa\u65b9\u6cd5"},"content":{"rendered":"\n<p>\u55b6\u696d\u65e5\u30d9\u30fc\u30b9\u3067\u306e\u9032\u6357\u7ba1\u7406\u3084\u52b4\u50cd\u65e5\u6570\u306e\u628a\u63e1\u3092\u3057\u305f\u3044\u3068\u304d\u306b\u4fbf\u5229\u306a\u306e\u304c\u3001<strong>\u55b6\u696d\u65e5\u6570<\/strong>\u3068<strong>\u7d4c\u904e\u55b6\u696d\u65e5\u6570<\/strong>\u306e\u7b97\u51fa\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6708\u521d\u304b\u3089\u6708\u672b\u307e\u3067\u306e\u55b6\u696d\u65e5\u6570\u3001\u305d\u3057\u3066<strong>\u672c\u65e5\u6642\u70b9\u307e\u3067\u306b\u4f55\u55b6\u696d\u65e5\u304c\u7d4c\u904e\u3057\u305f\u304b<\/strong>\u3092\u7c21\u5358\u306b\u6c42\u3081\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-border\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"365\" src=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/Screenshot_2019_0825_02.jpg\" alt=\"\" class=\"wp-image-236\" srcset=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/Screenshot_2019_0825_02.jpg 680w, https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/Screenshot_2019_0825_02-300x161.jpg 300w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u305d\u306e\u6708\u306e\u521d\u65e5\u3068\u6700\u7d42\u65e5\u3092\u53d6\u5f97\u3059\u308b<\/h2>\n\n\n\n<p>\u307e\u305a\u306f\u3001\u73fe\u5728\u306e\u6708\u306e\u958b\u59cb\u65e5\u30fb\u7d42\u4e86\u65e5\u3092\u95a2\u6570\u3067\u81ea\u52d5\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\u30bb\u30eb<\/th><th>\u5185\u5bb9<\/th><th>\u6570\u5f0f<\/th><\/tr><\/thead><tbody><tr><td>A2<\/td><td>\u4eca\u6708\u306e\u521d\u65e5<\/td><td><code>=EOMONTH(TODAY(), -1) + 1<\/code><\/td><\/tr><tr><td>B2<\/td><td>\u4eca\u6708\u306e\u6700\u7d42\u65e5<\/td><td><code>=EOMONTH(TODAY(), 0)<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u55b6\u696d\u65e5\u6570\u3092\u6c42\u3081\u308b<\/h2>\n\n\n\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u306f\u55b6\u696d\u65e5\u3092\u30ab\u30a6\u30f3\u30c8\u3059\u308b\u4fbf\u5229\u306a\u95a2\u6570 <code>NETWORKDAYS<\/code> \u304c\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>=NETWORKDAYS(A2, B2, D2:D)<\/code><\/pre><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>A2<\/code>: \u6708\u521d\u65e5<\/li>\n\n\n\n<li><code>B2<\/code>: \u6708\u672b\u65e5<\/li>\n\n\n\n<li><code>D2:D<\/code>: \u795d\u65e5\u306a\u3069\u306e<strong>\u9664\u5916\u65e5\uff08\u304a\u76c6\u3001\u5e74\u672b\u5e74\u59cb\u306a\u3069\uff09<\/strong><\/li>\n<\/ul>\n\n\n\n<p>\u4f8b\uff1a\u4eca\u6708\u306b\u304a\u76c6\uff088\u670814\u65e5\u301c16\u65e5\uff09\u306a\u3069\u306e\u7279\u5225\u4f11\u6687\u304c\u3042\u308b\u5834\u5408\u306f\u3001<strong>D\u5217\u306b\u305d\u306e\u65e5\u4ed8\u3092\u5165\u529b<\/strong>\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u795d\u65e5\u3092\u8abf\u3079\u308b\u65b9\u6cd5<\/h3>\n\n\n<div class=\"swell-block-postLink\">\t\t\t<a href=\"https:\/\/www8.cao.go.jp\/chosei\/shukujitsu\/gaiyou.html\" class=\"c-blogLink -external\" data-style=\"text\" target=\"_blank\" rel=\"noopener noreferrer\">\n\t\t\t\t<!-- <i class=\"c-blogLink__icon icon-link\" role=\"presentation\"><\/i> -->\n\t\t\t\t<span class=\"c-blogLink__icon\">\n\t\t\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"swl-svg-externalLink __svg\" width=\"1em\" height=\"1em\" viewBox=\"0 0 48 48\" role=\"img\" aria-hidden=\"true\" focusable=\"false\"><path d=\"M44 2H30c-1.1 0-2 .9-2 2s.9 2 2 2h9.2L24 21.2c-.8.8-.8 2 0 2.8s2 .8 2.8 0L42 8.8V18c0 1.1.9 2 2 2s2-.9 2-2V4c0-1.1-.9-2-2-2z\" \/><path d=\"M41 27c-1.1 0-2 .9-2 2v10c0 1.1-.9 2-2 2H9c-1.1 0-2-.9-2-2V11c0-1.1.9-2 2-2h10c1.1 0 2-.9 2-2s-.9-2-2-2H9c-3.3 0-6 2.7-6 6v28c0 3.3 2.7 6 6 6h28c3.3 0 6-2.7 6-6V29c0-1.1-.9-2-2-2z\" \/><\/svg>\t\t\t\t<\/span>\n\t\t\t\t<span class=\"c-blogLink__text\">\u56fd\u6c11\u306e\u795d\u65e5\u306b\u3064\u3044\u3066 &#8211; \u5185\u95a3\u5e9c<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\n\n<p>\u305f\u3068\u3048\u30702025\u5e74\u306e\u5834\u5408\u306f\u4ee5\u4e0b\u3092D2:D\u306b\u8cbc\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><th>2025\/01\/01<\/th><td>\u5143\u65e5<\/td><\/tr><tr><th>2025\/01\/13<\/th><td>\u6210\u4eba\u306e\u65e5<\/td><\/tr><tr><th>2025\/02\/11<\/th><td>\u5efa\u56fd\u8a18\u5ff5\u306e\u65e5<\/td><\/tr><tr><th>2025\/02\/23<\/th><td>\u5929\u7687\u8a95\u751f\u65e5<\/td><\/tr><tr><th>2025\/02\/24<\/th><td>\u632f\u66ff\u4f11\u65e5\uff08\u5929\u7687\u8a95\u751f\u65e5\uff09<\/td><\/tr><tr><th>2025\/03\/20<\/th><td>\u6625\u5206\u306e\u65e5<\/td><\/tr><tr><th>2025\/04\/29<\/th><td>\u662d\u548c\u306e\u65e5<\/td><\/tr><tr><th>2025\/05\/03<\/th><td>\u61b2\u6cd5\u8a18\u5ff5\u65e5<\/td><\/tr><tr><th>2025\/05\/04<\/th><td>\u307f\u3069\u308a\u306e\u65e5<\/td><\/tr><tr><th>2025\/05\/05<\/th><td>\u3053\u3069\u3082\u306e\u65e5<\/td><\/tr><tr><th>2025\/05\/06<\/th><td>\u632f\u66ff\u4f11\u65e5\uff08\u307f\u3069\u308a\u306e\u65e5\uff09<\/td><\/tr><tr><th>2025\/07\/21<\/th><td>\u6d77\u306e\u65e5<\/td><\/tr><tr><th>2025\/08\/11<\/th><td>\u5c71\u306e\u65e5<\/td><\/tr><tr><th>2025\/09\/15<\/th><td>\u656c\u8001\u306e\u65e5<\/td><\/tr><tr><th>2025\/09\/23<\/th><td>\u79cb\u5206\u306e\u65e5<\/td><\/tr><tr><th>2025\/10\/13<\/th><td>\u30b9\u30dd\u30fc\u30c4\u306e\u65e5<\/td><\/tr><tr><th>2025\/11\/03<\/th><td>\u6587\u5316\u306e\u65e5<\/td><\/tr><tr><th>2025\/11\/23<\/th><td>\u52e4\u52b4\u611f\u8b1d\u306e\u65e5<\/td><\/tr><tr><th>2025\/11\/24<\/th><td>\u632f\u66ff\u4f11\u65e5\uff08\u52e4\u52b4\u611f\u8b1d\u306e\u65e5\uff09<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div class=\"swell-block-accordion\">\n<details class=\"swell-block-accordion__item\" data-swl-acc=\"wrapper\"><summary class=\"swell-block-accordion__title\" data-swl-acc=\"header\"><span class=\"swell-block-accordion__label\">2026\u5e74\u306e\u5834\u5408<\/span><span class=\"swell-block-accordion__icon c-switchIconBtn\" data-swl-acc=\"icon\" aria-hidden=\"true\" data-opened=\"false\"><i class=\"__icon--closed icon-caret-down\"><\/i><i class=\"__icon--opened icon-caret-up\"><\/i><\/span><\/summary><div class=\"swell-block-accordion__body\" data-swl-acc=\"body\">\n<figure class=\"wp-block-table\"><table><tbody><tr><th>2026\/01\/01<\/th><td>\u5143\u65e5<\/td><\/tr><tr><th>2026\/01\/12<\/th><td>\u6210\u4eba\u306e\u65e5<\/td><\/tr><tr><th>2026\/02\/11<\/th><td>\u5efa\u56fd\u8a18\u5ff5\u306e\u65e5<\/td><\/tr><tr><th>2026\/02\/23<\/th><td>\u5929\u7687\u8a95\u751f\u65e5<\/td><\/tr><tr><th>2026\/03\/20<\/th><td>\u6625\u5206\u306e\u65e5<\/td><\/tr><tr><th>2026\/04\/29<\/th><td>\u662d\u548c\u306e\u65e5<\/td><\/tr><tr><th>2026\/05\/03<\/th><td>\u61b2\u6cd5\u8a18\u5ff5\u65e5<\/td><\/tr><tr><th>2026\/05\/04<\/th><td>\u307f\u3069\u308a\u306e\u65e5<\/td><\/tr><tr><th>2026\/05\/05<\/th><td>\u3053\u3069\u3082\u306e\u65e5<\/td><\/tr><tr><th>2026\/05\/06<\/th><td>\u632f\u66ff\u4f11\u65e5\uff08\u61b2\u6cd5\u8a18\u5ff5\u65e5\uff09<\/td><\/tr><tr><th>2026\/07\/20<\/th><td>\u6d77\u306e\u65e5<\/td><\/tr><tr><th>2026\/08\/11<\/th><td>\u5c71\u306e\u65e5<\/td><\/tr><tr><th>2026\/09\/21<\/th><td>\u656c\u8001\u306e\u65e5<\/td><\/tr><tr><th>2026\/09\/22<\/th><td>\u56fd\u6c11\u306e\u4f11\u65e5\uff08\u656c\u8001\u3068\u79cb\u5206\u306e\u9593\uff09<\/td><\/tr><tr><th>2026\/09\/23<\/th><td>\u79cb\u5206\u306e\u65e5<\/td><\/tr><tr><th>2026\/10\/12<\/th><td>\u30b9\u30dd\u30fc\u30c4\u306e\u65e5<\/td><\/tr><tr><th>2026\/11\/03<\/th><td>\u6587\u5316\u306e\u65e5<\/td><\/tr><tr><th>2026\/11\/23<\/th><td>\u52e4\u52b4\u611f\u8b1d\u306e\u65e5<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div><\/details>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u7d4c\u904e\u55b6\u696d\u65e5\u6570\u3092\u6c42\u3081\u308b<\/h2>\n\n\n\n<p>\u4eca\u65e5\u307e\u3067\u306b<strong>\u4f55\u55b6\u696d\u65e5\u7d4c\u904e\u3057\u305f\u304b<\/strong>\u3092\u77e5\u308a\u305f\u3044\u5834\u5408\u306f\u3053\u3061\u3089<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>=NETWORKDAYS(A2, TODAY(), D2:D)<\/code><\/pre><\/div>\n\n\n\n<p>\u4eca\u307e\u3067\u306e\u95a2\u6570\u3092\u307e\u3068\u3081\u308b\u3068\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u8868\u793a\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-border\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"365\" src=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/Screenshot_2019_0825_02.jpg\" alt=\"\" class=\"wp-image-236\" srcset=\"https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/Screenshot_2019_0825_02.jpg 680w, https:\/\/cg-method.com\/google\/wp-content\/uploads\/2025\/05\/Screenshot_2019_0825_02-300x161.jpg 300w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u6d3b\u7528\u30dd\u30a4\u30f3\u30c8<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u4eca\u6708\u306e <strong>\u55b6\u696d\u65e5\u6570<\/strong> \u3092\u57fa\u6e96\u306b\u300c\u9032\u6357\u7387\u300d\u3092\u7b97\u51fa\u3067\u304d\u307e\u3059\u3002<\/li>\n\n\n\n<li>\u7d4c\u904e\u55b6\u696d\u65e5\u6570 \u00f7 \u7dcf\u55b6\u696d\u65e5\u6570 \u00d7 100 \u3067 <strong>\u55b6\u696d\u65e5\u30d9\u30fc\u30b9\u306e\u9032\u6357\u7ba1\u7406<\/strong>\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/li>\n<\/ul>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>=NETWORKDAYS(A2, TODAY(), D2:D) \/ NETWORKDAYS(A2, B2, D2:D)<\/code><\/pre><\/div>\n\n\n\n<p>\u3053\u308c\u3067 <strong>\u4eca\u6708\u306e\u55b6\u696d\u65e5\u9032\u6357\u7387\uff080\u301c1\u306e\u5c0f\u6570\uff09<\/strong> \u304c\u5f97\u3089\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u307e\u3068\u3081<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u55b6\u696d\u65e5\u6570\u30fb\u7d4c\u904e\u55b6\u696d\u65e5\u6570\u306f <code>NETWORKDAYS<\/code> \u95a2\u6570\u3067\u7c21\u5358\u306b\u7b97\u51fa\u3067\u304d\u308b<\/li>\n\n\n\n<li><code>EOMONTH<\/code> \u3068\u7d44\u307f\u5408\u308f\u305b\u3066\u3001<strong>\u6bce\u6708\u81ea\u52d5\u66f4\u65b0\u3055\u308c\u308b\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9<\/strong>\u304c\u4f5c\u6210\u53ef\u80fd<\/li>\n\n\n\n<li>\u795d\u65e5\u3084\u4f1a\u793e\u306e\u7279\u5225\u4f11\u65e5\u306f\u7b2c\u4e09\u5f15\u6570\u3067\u67d4\u8edf\u306b\u9664\u5916\u3067\u304d\u308b<\/li>\n<\/ul>\n\n\n\n<p>\u65e5\u5225\u3067\u306f\u306a\u304f<strong>\u55b6\u696d\u65e5\u30d9\u30fc\u30b9\u3067\u76ee\u6a19\u9032\u6357\u3092\u7ba1\u7406\u3057\u305f\u3044\u65b9<\/strong>\u306b\u3068\u3063\u3066\u3001\u3068\u3066\u3082\u5f79\u7acb\u3064\u30c6\u30af\u30cb\u30c3\u30af\u3067\u3059\u3002<br>\u55b6\u696d\u7ba1\u7406\u30fb\u4eba\u4e8b\u7ba1\u7406\u30fb\u7a3c\u50cd\u65e5\u5831\u306a\u3069\u3001\u3055\u307e\u3056\u307e\u306a\u5834\u9762\u3067\u3054\u6d3b\u7528\u304f\u3060\u3055\u3044\uff01<\/p>\n\n\n\n\n","protected":false},"excerpt":{"rendered":"<p>\u55b6\u696d\u65e5\u30d9\u30fc\u30b9\u3067\u306e\u9032\u6357\u7ba1\u7406\u3084\u52b4\u50cd\u65e5\u6570\u306e\u628a\u63e1\u3092\u3057\u305f\u3044\u3068\u304d\u306b\u4fbf\u5229\u306a\u306e\u304c\u3001\u55b6\u696d\u65e5\u6570\u3068\u7d4c\u904e\u55b6\u696d\u65e5\u6570\u306e\u7b97\u51fa\u3067\u3059\u3002 \u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6708\u521d\u304b\u3089\u6708\u672b\u307e\u3067\u306e\u55b6\u696d\u65e5\u6570\u3001\u305d\u3057\u3066\u672c\u65e5\u6642\u70b9\u307e\u3067\u306b\u4f55\u55b6\u696d\u65e5\u304c\u7d4c\u904e\u3057\u305f\u304b\u3092\u7c21\u5358\u306b\u6c42\u3081\u308b\u65b9\u6cd5 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":237,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","footnotes":""},"categories":[17],"tags":[9],"class_list":["post-234","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheets","tag-free"],"_links":{"self":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts\/234","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/comments?post=234"}],"version-history":[{"count":2,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts\/234\/revisions"}],"predecessor-version":[{"id":238,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/posts\/234\/revisions\/238"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/media\/237"}],"wp:attachment":[{"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/media?parent=234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/categories?post=234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cg-method.com\/google\/wp-json\/wp\/v2\/tags?post=234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}