{"id":4527,"date":"2023-08-04T19:18:09","date_gmt":"2023-08-04T10:18:09","guid":{"rendered":"https:\/\/onechat.jp\/blog\/?p=4527"},"modified":"2025-03-17T11:35:56","modified_gmt":"2025-03-17T02:35:56","slug":"%e3%82%b9%e3%83%97%e3%83%ac%e3%83%83%e3%83%89%e3%82%b7%e3%83%bc%e3%83%88%e3%81%a7%e6%9c%88%e6%9c%ab%e3%83%bb%e6%9c%88%e5%88%9d%e3%82%92%e4%b8%80%e7%99%ba%e3%81%a7%e5%87%ba%e3%81%99%e9%96%a2%e6%95%b0","status":"publish","type":"post","link":"https:\/\/onechat.jp\/blog\/archives\/4527","title":{"rendered":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6708\u672b\u30fb\u6708\u521d\u3092\u4e00\u767a\u3067\u51fa\u3059\u95a2\u6570\u304c\u3042\u308b\uff1f\u4f7f\u3044\u65b9\u3092\u89e3\u8aac"},"content":{"rendered":"\n<p>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u306f\u3001\u6708\u672b\u3084\u6708\u521d\u306e\u65e5\u4ed8\u3092\u81ea\u52d5\u3067\u5165\u529b\u3059\u308b\u95a2\u6570\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u4f8b\u3048\u3070\u8acb\u6c42\u66f8\u30fb\u7d0d\u54c1\u66f8\u30fb\u9818\u53ce\u66f8\u30fb\u7533\u8acb\u66f8\u30fb\u8a3c\u660e\u66f8\u306a\u3069\u3001\u65e5\u4ed8\u306e\u8a18\u8f09\u304c\u5fc5\u9808\u306e\u66f8\u985e\u4f5c\u6210\u6642\u306b\u5f79\u7acb\u3064\u3067\u3057\u3087\u3046\u3002\u95a2\u6570\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u624b\u5165\u529b\u306b\u3088\u308b\u30df\u30b9\u3082\u4e88\u9632\u3067\u304d\u3001\u696d\u52d9\u52b9\u7387\u5316\u3082\u3067\u304d\u308b\u306e\u3067\u305c\u3072\u6d3b\u7528\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6708\u672b\u3084\u6708\u521d\u306e\u65e5\u4ed8\u3092\u81ea\u52d5\u3067\u5165\u529b\u3059\u308b\u95a2\u6570\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002\u571f\u65e5\u795d\u65e5\u3092\u9664\u304d\u5e73\u65e5\u306e\u307f\u3092\u6307\u5b9a\u3059\u308b\u65b9\u6cd5\u3084\u3001\u30d0\u30e9\u30d0\u30e9\u306e\u6708\u6570\u5206\u3060\u3051\u5f8c\u306e\u6708\u672b\u65e5\u3092\u8868\u793a\u3055\u305b\u308b\u65b9\u6cd5\u306b\u3082\u89e6\u308c\u308b\u305f\u3081\u3054\u53c2\u8003\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n<div class=\"cta_article_top\">\r\n\t<h2>\r\n\t\t\u30c1\u30e3\u30c3\u30c8\u4e00\u62ec\u7ba1\u7406\u30a2\u30d7\u30ea\u300cOneChat\u300d\u304c\u4eca\u306a\u3089\u521d\u6708\u7121\u6599!!\r\n\t<\/h2>\r\n\t<a href=\"https:\/\/onechat.jp\" onclick=\"ga('send','event','cta','click','banner',1);\" target=\"_blank\" rel=\"noopener\">\r\n\t<img decoding=\"async\" src=\"https:\/\/onechat.jp\/blog\/wp-content\/uploads\/cta\/OGP.png\">\r\n\t<\/a>\r\n\t<p class=\"cta\">\r\nOneChat\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u306f<a href=\"https:\/\/onechat.jp\" onclick=\"ga('send','event','cta','click','banner',1);\" target=\"_blank\" rel=\"noopener\">\u3053\u3061\u3089<\/a>\u304b\u3089\r\n\t<\/p>\r\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6708\u672b\u3092\u8868\u793a\u3057\u305f\u3044\u5834\u5408<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/MxugTzEjCMBbJGmHuOCL6k4ViNYnTP_4-clzbzG_N12qG-HFR3aTfT-S4lOY3e4omkubc1oewHKgS2aRSh4951kR0ztTI3ooQti2b7CdCLa-jrSWEVtyljCT_ZOHY7Ap9czxYItfgJrbtewEys7uvOw\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6708\u672b\u3092\u8868\u793a\u3057\u305f\u3044\u5834\u5408\u306e\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002\u300c\u8acb\u6c42\u66f8\u306b\u5165\u529b\u3057\u305f\u767a\u884c\u65e5\u306e\u7fcc\u6708\u672b\u65e5\u3092\u632f\u8fbc\u671f\u9650\u3068\u3057\u3066\u81ea\u52d5\u5165\u529b\u3057\u305f\u3044\u300d\u306a\u3069\u306e\u5834\u9762\u3067\u5f79\u7acb\u3061\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">EOMONTH\u95a2\u6570\u3092\u5229\u7528<\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/O_AiTz21LkYXTHY5m1dXU3EFsp7gFzu7d7IZEUtQq19Gke4JUkZk3YT_ZvfYaTnNYL9XLf__GSOlg77P-9FrNohzOhO3C030TXAobM2REGM6F9zGLXjQeml1OcZ-RXVCRdVOacOdDaADwYI_OtEte6M\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6708\u672b\u3092\u8868\u793a\u3059\u308b\u969b\u306f\u3001EOMONTH\u95a2\u6570\u3092\u4f7f\u3044\u307e\u3059\u3002EOMONTH\u95a2\u6570\u306f\u6307\u5b9a\u3057\u305f\u65e5\u4ed8\u3092\u57fa\u6e96\u306b\u3001\u305d\u306e\u524d\u5f8c\u6708\u306e\u6700\u7d42\u65e5\u3092\u81ea\u52d5\u3067\u6c42\u3081\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u4eca\u56de\u306f\u300c\u767a\u884c\u65e5\u300d\u304b\u30891\u30f6\u6708\u5f8c\u306e\u6708\u672b\u3092\u300c\u304a\u652f\u6255\u671f\u9650\u300d\u306b\u5165\u529b\u3057\u305f\u3044\u305f\u3081\u3001\u300c=EOMONTH(C5,1)\u300d\u306e\u95a2\u6570\u3092\u4f7f\u3063\u3066\u3044\u307e\u3059\u3002C5\u306b\u5165\u529b\u3057\u305f\u65e5\u4ed8\u306e1\u30f6\u6708\u5f8c\u306e\u6708\u672b\u3092\u5165\u529b\u3059\u308b\u3001\u3068\u3044\u3046\u610f\u5473\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u767a\u884c\u65e5\u306e\u6b04\u306bTODAY\u95a2\u6570\u3092\u8a2d\u5b9a\u3057\u3066\u304a\u304f\u306e\u3082\u4fbf\u5229\u3067\u3059\u3002TODAY\u95a2\u6570\u306f\u672c\u65e5\u306e\u65e5\u4ed8\u3092\u81ea\u52d5\u5165\u529b\u3059\u308b\u95a2\u6570\u3067\u3042\u308a\u3001\u300c=TODAY()\u300d\u3068\u8868\u8a18\u3057\u307e\u3059\u3002\u81ea\u52d5\u3067\u7b97\u51fa\u3057\u3066\u304f\u308c\u308b\u305f\u3081\u3001\u9762\u5012\u306a\u65e5\u4ed8\u306e\u624b\u5165\u529b\u3084\u30df\u30b9\u3092\u6e1b\u3089\u3059\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/fxBuf_HkE4sUtp8lcAjHJpJhJhdVzATpXmgYoS2cauzuTvXKjBKgZJYC-Nw8W2ZTa_Z_uIg4NWeoOJBW-2X7B3SE2SEnOMdytQxsTBrBXodxRt2Tdd1Hm6QGYm8_V1hBf9mzc2SkMvwrNBH6HKWEVNw\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u6570\u30f6\u6708\u5f8c\u306e\u6708\u672b\u3092\u8868\u793a\u3057\u305f\u3044\u5834\u5408<\/h3>\n\n\n\n<p>\u6570\u30f6\u6708\u5f8c\u306e\u6708\u672b\u3092\u8868\u793a\u3057\u305f\u3044\u5834\u5408\u3001\u6708\u6570\u3092\u6307\u5b9a\u3059\u308b\u90e8\u5206\u3060\u3051\u5909\u66f4\u3057\u3066\u8abf\u6574\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/q7Hb2saKjnRmMq-vOMorOHw5RRk4bzOd1NM-wxMbYft6zr59LAfJa2Y0W_sMYkxp-a_Le3pjcfFXnQolnPSONIWS5EIjeEK7O2bQV0992aqjfcqHClLzJuXXRpVhAfNPN48wjGuO4JW1sCQhpTvknoc\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>1\u30f6\u6708\u5f8c\u3067\u3042\u308c\u3070\u300c=EOMONTH(C10,1)\u300d\u30012\u30f6\u6708\u5f8c\u3067\u3042\u308c\u3070\u300c=EOMONTH(C10,2)\u300d\u2026\u3068\u5909\u66f4\u3057\u307e\u3059\u3002\u300c\u57fa\u6e96\u65e5\u304b\u3089\u4f55\u30f6\u6708\u5f8c\u304b\u300d\u3067\u8003\u3048\u308b\u3068\u308f\u304b\u308a\u3084\u3059\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6708\u521d\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u5834\u5408<\/h2>\n\n\n\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6708\u521d\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u5834\u5408\u3082\u3001EOMONTH\u95a2\u6570\u304c\u4f7f\u3048\u307e\u3059\u3002\u6708\u672b\u3092\u5165\u529b\u3059\u308b\u95a2\u6570\u306e\u6700\u5f8c\u306b\u300c+1\u300d\u3092\u5165\u529b\u3059\u308c\u3070\u300c\u6708\u672b\u6700\u7d42\u65e5\u306e\u7fcc\u65e5\u300d\u3068\u306a\u308a\u3001\u6b21\u6708\u306e\u6708\u521d\u3092\u793a\u3059\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/tBbi62Y_Up7sSOKoNJt3R0fGwC8r0naAi5vLwIJr-YjLiBYXN_JJ6nszo2nAwrhUMRRRU7i4-dSs4jI9nsa2mO1uxcjcjpDLwT17zSn3oQC0mIWPq8-Kv_BB20wozq4-oRltIaGv_VKH36LyUOhVAbA\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>\u4eca\u56de\u306f\u300c\u767a\u884c\u65e5\u300d\u304b\u30891\u30f6\u6708\u7d4c\u904e\u3057\u305f\u5f8c\u306e\u6708\u521d\u3092\u300c\u304a\u652f\u6255\u671f\u9650\u300d\u306b\u5165\u529b\u3057\u305f\u3044\u305f\u3081\u3001\u300c=EOMONTH(C5,1)+1\u300d\u306e\u95a2\u6570\u3092\u4f7f\u3063\u3066\u3044\u307e\u3059\u3002C5\u306b\u5165\u529b\u3057\u305f\u65e5\u4ed8\u306e1\u30f6\u6708\u5f8c\u306e\u7fcc\u6708\u521d\u65e5\u3092\u5165\u529b\u3059\u308b\u3001\u3068\u3044\u3046\u610f\u5473\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/qX-0_-3UPcEjSedT9WsG9J_T702J2rVjbWr882KrBfeD7XeEq1d2TxagtE8nXlYn6CR8nuxEM7wJmLHoxbw-Mz1DTzkViCkU-6v7u-mnTlh-NdQ8MkY_GLpQUNVC--4e8CQtziqJrV_fd8B6mea5RGI\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>\u6570\u30f6\u6708\u7d4c\u904e\u5f8c\u306e\u7fcc\u6708\u521d\u65e5\u3092\u5165\u529b\u3057\u305f\u3044\u5834\u5408\u30011\u30f6\u6708\u5f8c\u3067\u3042\u308c\u3070\u300c=EOMONTH(C10,1)+1\u300d\u30012\u30f6\u6708\u524d\u3067\u3042\u308c\u3070\u300c=EOMONTH(C10,2)+1\u300d\u3068\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u6708\u672b\u30fb\u6708\u521d\u304b\u3089\u4efb\u610f\u306e\u65e5\u4ed8\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u5834\u5408<\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/Gzlnm0jMa4E9xlI2xaneHYdZqlN18KKPxaptHzJpIYJ_XPqaNa9Uuj6wnVlhcT3d58ihZ-LEFmMlpT2ha0itqCS24LbXHhiZ8yBALPmaJYuwQ9gxVrZ6OcBXxwJa9XSZNVAhD3-gmpJO1T88vD63hX8\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>\u6708\u672b\u3084\u6708\u521d\u304b\u3089\u4efb\u610f\u306e\u65e5\u4ed8\u3092\u8868\u793a\u3055\u305b\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002EOMONTH\u95a2\u6570\u3092\u4efb\u610f\u306e\u5f62\u5f0f\u306b\u5408\u308f\u305b\u308c\u3070\u7c21\u5358\u306b\u8abf\u6574\u3067\u304d\u308b\u306e\u3067\u3001\u4e0b\u8a18\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u5165\u529b\u3057\u305f\u5f53\u6708\u306e\u6708\u672b\u3092\u77e5\u308a\u305f\u3044\u5834\u5408<\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/P13oOhBxxuq3HE_SO_TLOcbSfyp015FUcX3-NxFSN6YSeGIXLkrXyTU8vXfzxnLnjrV6llEesdeFTes5ffhQoXoXSJpr1phNFeasstPlLhFPTaShtei3G0Uw5lCw9aFMeKo2SOfC4cJbuafsRxRmKRs\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>\u5165\u529b\u3057\u305f\u5f53\u6708\u306e\u6708\u672b\u3092\u77e5\u308a\u305f\u3044\u3068\u304d\u306f\u3001\u300c=EOMONTH(C5,0)\u300d\u3068\u8868\u8a18\u3057\u307e\u3059\u30021\u30f6\u6708\u5f8c\u304c\u300c1\u300d\u30011\u30f6\u6708\u524d\u304c\u300c-1\u300d\u3067\u3042\u308b\u305f\u3081\u3001\u5f53\u6708\u306f\u300c0\u300d\u3068\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u5165\u529b\u3057\u305f\u65e5\u4ed8\u306e\u524d\u6708\u306e\u672b\u65e5\u3092\u77e5\u308a\u305f\u3044\u5834\u5408<\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/yKyzQSQRu-3cnVMbiVJ_erRtJ4EBxWT9mZyTV5YpErtGiSXyzJeQkg5FF954rD2mWT1dw8OcIsTbNtSZz8sLlMWLmZ7BWpB5BpPAE6f-loXozJC3qlezWg7OhB_C0iOjSmtnjjH28Vgl1bjnqzEDwCM\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>\u6570\u30f6\u6708\u524d\u306e\u6708\u672b\u3092\u8868\u793a\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u30021\u30f6\u6708\u524d\u3067\u3042\u308c\u3070\u300c=EOMONTH(C10,-1)\u300d\u30012\u30f6\u6708\u524d\u3067\u3042\u308c\u3070\u300c=EOMONTH(C10,-2)\u300d\u3068\u5909\u66f4\u3057\u307e\u3059\u3002\u300c\u57fa\u6e96\u65e5\u304b\u3089\u4f55\u30f6\u6708\u524d\u304b\u300d\u3092\u57fa\u6e96\u306b\u3001\u6708\u6570\u306e\u90e8\u5206\u306b\u300c-\uff08\u30de\u30a4\u30ca\u30b9\uff09\u300d\u3092\u3064\u3051\u3066\u6d3b\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u5165\u529b\u3057\u305f\u65e5\u4ed8\u304b\u30891\u30f6\u6708\u5f8c\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u5834\u5408<\/h3>\n\n\n\n<p>\u5165\u529b\u3057\u305f\u65e5\u4ed8\u304b\u30891\u30f6\u6708\u5f8c\u306b\u8868\u793a\u3055\u305b\u305f\u3044\u5834\u5408\u306f\u3001EDATE\u95a2\u6570\u3092\u4f7f\u3044\u307e\u3059\u3002EDATE\u95a2\u6570\u306f\u6307\u5b9a\u3057\u305f\u958b\u59cb\u65e5\u3092\u57fa\u6e96\u306b\u3001\u6307\u5b9a\u3057\u305f\u6708\u6570\u3060\u3051\u524d\u5f8c\u306e\u65e5\u4ed8\u3092\u8fd4\u3059\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/PMlLNMpOAdgQCFG4__PK-AoMpTuPwoJ4VdZFoB3TG4OTg6dFPRiZisCWrfUWYJdS0bVul5b2aX2M6_r5F5bSBiw6xTsX-4LY5djtig0nQ2SJI_FBSMXvtuQPZgXpce076M6Stb_S98AjcHHEyP67yMw\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>C10\u30bb\u30eb\u306b\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u672c\u65e5\uff08203\/07\/27\uff09\u3092\u57fa\u6e96\u306b\u3057\u305f\u3044\u5834\u5408\u30011\u30f6\u6708\u5f8c\u3067\u3042\u308c\u3070\u300c\u3000=EDATE(C10,1)\u300d\u30012\u30f6\u6708\u5f8c\u3067\u3042\u308c\u3070\u300c=EDATE(C10,2)\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002\u3061\u3087\u3046\u30691\u30f6\u6708\u5f8c\u306e\u65e5\u4ed8\u304c\u81ea\u52d5\u3067\u5165\u529b\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u95a2\u9023\u8a18\u4e8b\uff1a<a href=\"https:\/\/onechat.jp\/blog\/archives\/1754\" target=\"_blank\" rel=\"noreferrer noopener\">\u3010\u521d\u5fc3\u8005\u5411\u3051\u3011Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u5165\u529b\u898f\u5247\u3092\u4f7f\u3044\u3053\u306a\u3059\u65b9\u6cd5\u3092\u5fb9\u5e95\u89e3\u8aac\u3057\u307e\u3059\uff01<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u3088\u304f\u3042\u308b\u8cea\u554f<\/h2>\n\n\n\n<p>\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6708\u672b\u3084\u6708\u521d\u3092\u81ea\u52d5\u5165\u529b\u3059\u308b\u3053\u3068\u306b\u95a2\u3057\u3066\u300c\u3088\u304f\u3042\u308b\u8cea\u554f\u300d\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30d0\u30e9\u30d0\u30e9\u306e\u6708\u6570\u5206\u3060\u3051\u5f8c\u306e\u6708\u672b\u65e5\u3092\u8868\u793a\u3055\u305b\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u3059\u304b\uff1f<\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/ARFdWCrOEvhMQJGL6P356953QHlMQU1JqJBfniW_ca_OUYD5j1z56auS2-IOyZ9CI27TqLV5KfHW1DR2IvDorxaKD5_HKopYfCZ6rHeV5Bt9wtkWHDm2niE3E9hm7IgYSkcllChCLQCKNNuJnoVPJBo\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>\u57fa\u6e96\u65e5\u304b\u3089\u6307\u5b9a\u6708\u6570\u5206\u3060\u3051\u5f8c\u306e\u6708\u672b\u6700\u7d42\u65e5\u3092\u5165\u529b\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u300c=EOMONTH(\u57fa\u6e96\u65e5,\u6708\u6570)\u300d\u3092\u5165\u529b\u3057\u307e\u3059\u3002\u300c=EOMONTH(B3,C3)\u300d\u3067\u3001B3\u306b\u5165\u529b\u3055\u308c\u305f\u65e5\u304b\u3089\u3001C3\u306b\u5165\u529b\u3055\u308c\u305f4\u30f6\u6708\u5f8c\u306e\u6708\u672b\u3092\u5165\u529b\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/JMKOWbuc4Ceig1IdNAcX03sTm5v2-k7vovNtsMgP3LGFoCd3XktR4n6sMhIST6qdfzBz1pTfvvnVOm06VGtdyyTueYqKhg-fhqqgQp42EvSJedYQ2lLYWsUp0QOFJvS0YKJmb1T5AA8KzpiMiAHa-G4\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>\u4ed6\u306e\u30bb\u30eb\u306b\u3082\u540c\u69d8\u306eEOMONTH\u95a2\u6570\u3092\u4f7f\u3046\u3053\u3068\u3067\u3001\u671f\u9593\u304c\u30d0\u30e9\u30d0\u30e9\u3067\u3082\u8a72\u5f53\u3059\u308b\u6708\u6570\u5206\u3060\u3051\u5f8c\u306e\u6708\u672b\u65e5\u3092\u8868\u793a\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6708\u3084\u65e5\u4ed8\u3060\u3051\u3067\u306f\u306a\u304f\u66dc\u65e5\u3082\u4e00\u7dd2\u306b\u8868\u793a\u3055\u305b\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u3059\u304b\uff1f<\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/uSTDXzPoSNBI7OtKVTzW6gp5uoRm1uDEKn8uFGUr6XtS_EMCrxIwIkNywrkEYC-dnOJOD7NGPgkoXXNGlrVk_KuQm02tZMQw248M2ggexo4ztSKom6_YNYBsxvXHn8CxeeOcRZALKnoUNlZangDun4k\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>\u30101\u3011\u66dc\u65e5\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u30bb\u30eb\u3092\u9078\u629e\u3057\u3001\u300c\u8868\u793a\u5f62\u5f0f\u300d\u30bf\u30d6\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/N43sJhhynOaLXdgbuiQP0KO5gUOpfFxVSxAsFugBrZ8TSOATz-ipgoZu5MPJKHPDaDSAWGGhFx_etUEPTyebMhP9YGpcFxHyZpIXqjpclPinc2bpsaoeJvwywnneiHjmVzOipHsbpoLk38SGz_ptLd4\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>\u30102\u3011\u300c\u6570\u5b57\u300d\u304b\u3089\u300c\u30ab\u30b9\u30bf\u30e0\u6570\u5024\u5f62\u5f0f\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/gHOPYFUqJSekxnwuffIKtmMJh161S_BDEfiXW1ij_eP0wZT0s6oIRjT1c5KF2pmTdvn9_i-oESjxz-92C0vTShFX7Ne0Voapzhke2MgtyZTa6Q-0zTI8xMr5AMsLosmus-iFU2Yd5rZrA50C3sUo6Lg\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>\u30103\u3011\u30ab\u30b9\u30bf\u30e0\u6570\u5024\u5f62\u5f0f\u306e\u9805\u76ee\u306b\u3001\u300cm\u6708d\u65e5(aaa)\u300d\u3068\u5165\u529b\u3001\u300c\u9069\u7528\u300d\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u300cm\u300d\u304c\u6708\u3092\u3001\u300cd\u300d\u304c\u65e5\u4ed8\u3092\u3001\u300c(aaa)\u300d\u304c\u66dc\u65e5\u3092\u8868\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/lorZeVsFmBC-R9wuL8WDTcr0qSUx0i2Ic8uy_8m3g6IXlR-aey2ZrJKvHHW0r0P87llPxLi4TYQdX0GVMf2TutxpkZKAZbdG5Or0uIPrXKI1MUd8o8VO30GCNYFMCwGk3hY0dnAYMLligALru7JguPM\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>\u30104\u3011\u65e5\u4ed8\u306b\u66dc\u65e5\u3082\u5165\u529b\u3067\u304d\u307e\u3059\u3002\u5e74\u3082\u5165\u529b\u3057\u305f\u3044\u3068\u304d\u306f\u300cyyyy\u5e74m\u6708d\u65e5(aaa)\u300d\u3068\u8868\u8a18\u3059\u308c\u3070\u3001\u300c2023\u5e747\u670827\u65e5(\u6728)\u300d\u3068\u8a18\u8f09\u3055\u308c\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6708\u672b\u3067\u306f\u306a\u304f\u6708\u6700\u5f8c\u306e\u55b6\u696d\u65e5\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u5834\u5408\u306f\u3069\u3046\u3057\u305f\u3089\u3044\u3044\u3067\u3059\u304b\uff1f<\/h3>\n\n\n\n<p>\u6708\u6700\u5f8c\u306e\u55b6\u696d\u65e5\u3092\u8868\u793a\u3055\u305b\u308b\u3068\u304d\u306f\u3001WORKDAY\u95a2\u6570\u3068EOMONTH\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u307e\u3059\u3002WORKDAY\u95a2\u6570\u306f\u3001\u571f\u65e5\u3084\u6307\u5b9a\u3055\u308c\u305f\u795d\u65e5\u3092\u9664\u304f\u65e5\u4ed8\u3092\u6307\u5b9a\u3067\u304d\u308b\u95a2\u6570\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/_zfSvGGUVMTaicZif13-b4fLN8qEr-b0uHX1qojxFk3MhB6yiKUfb9rOOeEi2ZjK4lKusgrnCqHKQEdB5lLmtlq6bGkC79yo8dTeWGmS1RNAsAg4wq2YWxYLLDGmOtlFMTVGt-b2kl9ZDb_JzauKX8s\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>\u30101\u3011\u5f53\u6708\u306e\u6700\u7d42\u55b6\u696d\u65e5\u3092\u5165\u529b\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u300c=WORKDAY(EOMONTH(C18,0)+1,-1)\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u3002C18\u30bb\u30eb\u306b\u5165\u529b\u3055\u308c\u305f\u672c\u65e5\u304b\u3089\u30010\u30f6\u6708\u5f8c\uff08\u4eca\u6708\uff09\u306b\u304a\u3051\u308b\u7fcc\u67081\u65e5\u306e\u76f4\u524d\u306e\u5e73\u65e5\u3001\u3092\u610f\u5473\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/03DsVLxEYs_kNLcdFjO1bsDzl69x_a05NL5wnNlZNHFYjzU94oIH-ouDiKoB633hQ82dtNf5ZNWa3JZ3RLT1vNCYYTym15S4tEU0Y8SoEcrGhd7xDugv6qYK9841Z8tH57HnTSUOYusq3xRBz-hz3S8\" alt=\"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8 \u6708\u672b \u95a2\u6570\"\/><\/figure>\n\n\n\n<p>&nbsp;\u30102\u30112\u30f6\u6708\u5f8c\u306e\u6700\u7d42\u55b6\u696d\u65e5\u3092\u6c42\u3081\u305f\u3044\u5834\u5408\u306f\u3001\u300c=WORKDAY(EOMONTH(C18,2)+1,-1)\u300d\u3068\u5165\u529b\u3057\u307e\u3059\u30029\u6708\u306f30\u65e5\u307e\u3067\u3042\u308a\u307e\u3059\u304c\u30012023\u5e749\u670830\u65e5\u306f\u571f\u66dc\u65e5\u3067\u3042\u308b\u305f\u3081\u3001\u524d\u65e5\u306e29\u65e5\u91d1\u66dc\u65e5\u304c\u81ea\u52d5\u3067\u5165\u529b\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u307e\u3068\u3081<\/h2>\n\n\n\n<p>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u4e0a\u3067EOMONTH\u95a2\u6570\u3092\u4f7f\u3044\u3001\u6708\u672b\u3084\u6708\u521d\u3092\u81ea\u52d5\u8868\u8a18\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308c\u3070\u3001\u30ab\u30ec\u30f3\u30c0\u30fc\u3092\u898b\u306a\u304c\u3089\u624b\u5165\u529b\u3059\u308b\u624b\u9593\u3092\u7701\u3051\u307e\u3059\u3002\u30df\u30b9\u306e\u4e88\u9632\u3084\u696d\u52d9\u52b9\u7387\u5316\u306b\u3082\u8ca2\u732e\u3059\u308b\u306e\u3067\u3001\u3053\u308c\u307e\u3067\u624b\u5165\u529b\u3057\u3066\u3044\u305f\u65b9\u306f\u8a66\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002\u66dc\u65e5\u3082\u81ea\u52d5\u3067\u5165\u529b\u3067\u304d\u308b\u305f\u3081\u3001\u30bf\u30b9\u30af\u7ba1\u7406\u3084\u30b9\u30b1\u30b8\u30e5\u30fc\u30eb\u7ba1\u7406\u3067\u3082\u5f79\u7acb\u3061\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u4ed6\u306b\u3082\u3001\u571f\u65e5\u795d\u65e5\u306a\u3069\u5e97\u8217\u4f11\u696d\u65e5\u3092\u8997\u3044\u3066\u6708\u672b\u3084\u6708\u521d\u3092\u81ea\u52d5\u8868\u8a18\u3059\u308b\u65b9\u6cd5\u3082\u3042\u308a\u307e\u3059\u3002\u55b6\u696d\u65e5\u306b\u5408\u308f\u305b\u3066\u7de0\u5207\u3092\u8a2d\u5b9a\u3057\u305f\u3044\u5834\u9762\u3084\u3001\u5e73\u65e5\u9650\u5b9a\u3067\u30bf\u30b9\u30af\u3092\u5165\u308c\u305f\u3044\u3068\u304d\u306b\u4fbf\u5229\u306a\u306e\u3067\u6d3b\u7528\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u6708\u672b\u30fb\u6708\u521d\u306b\u95a2\u3059\u308b\u91cd\u8981\u7528\u8a9e<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>\u7528\u8a9e<\/td><td>\u610f\u5473<\/td><\/tr><tr><td>EOMONTH\u95a2\u6570<\/td><td>\u6307\u5b9a\u3057\u305f\u65e5\u4ed8\u3092\u57fa\u6e96\u306b\u3001\u305d\u306e\u524d\u5f8c\u6708\u306e\u6700\u7d42\u65e5\u3092\u81ea\u52d5\u3067\u6c42\u3081\u308b\u95a2\u6570\u3002\u300c=EOMONTH(\u57fa\u6e96\u65e5\u3092\u8868\u3059\u30bb\u30eb\u306e\u756a\u53f7,\u6708\u6570)\u300d\u3068\u8868\u8a18\u3057\u307e\u3059\u3002<\/td><\/tr><tr><td>TODAY\u95a2\u6570<\/td><td>\u672c\u65e5\u306e\u65e5\u4ed8\u3092\u81ea\u52d5\u5165\u529b\u3059\u308b\u95a2\u6570\u3002\u300c=TODAY()\u300d\u3068\u8868\u8a18\u3057\u307e\u3059\u3002<\/td><\/tr><tr><td>EDATE\u95a2\u6570<\/td><td>\u6307\u5b9a\u3057\u305f\u958b\u59cb\u65e5\u3092\u57fa\u6e96\u306b\u3001\u6307\u5b9a\u3057\u305f\u6708\u6570\u3060\u3051\u524d\u5f8c\u306e\u65e5\u4ed8\u3092\u8fd4\u3059\u95a2\u6570\u3002\u300c=EDATE(\u57fa\u6e96\u65e5\u3092\u8868\u3059\u30bb\u30eb\u306e\u756a\u53f7,\u6708\u6570)\u300d\u3068\u8868\u8a18\u3057\u307e\u3059\u3002<\/td><\/tr><tr><td>WORKDAY\u95a2\u6570<\/td><td>\u571f\u65e5\u3084\u6307\u5b9a\u3055\u308c\u305f\u795d\u65e5\u3092\u9664\u304f\u65e5\u4ed8\u3092\u6307\u5b9a\u3067\u304d\u308b\u95a2\u6570\u3002EOMONTH\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u3001\u57fa\u6e96\u65e5\u304b\u3089\u6307\u5b9a\u6708\u6570\u5206\u3092\u524d\u5f8c\u3055\u305b\u305f\u5e73\u65e5\u3092\u8868\u793a\u3067\u304d\u307e\u3059\u3002<\/td><\/tr><tr><td>\u65e5\u4ed8\u306e\u8868\u8a18\u65b9\u6cd5<\/td><td>\u5e74\uff08yeaar\uff09\u30fb\u6708\uff08month\uff09\u30fb\u65e5\uff08day\uff09\u3067\u8868\u8a18\u3057\u307e\u3059\u3002yyyy\/mm\/dd\u3067\u3042\u308c\u3070\u30012023\/07\/27\u3068\u897f\u66a6\u3067\u8868\u8a18\u3067\u304d\u307e\u3059\u3002\u66dc\u65e5\u3092\u52a0\u3048\u305f\u3044\u3068\u304d\u306f\u6700\u5f8c\u306b\u300c(aaa)\u300d\u3092\u52a0\u3048\u307e\u3059\u3002<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u306f\u3001\u6708\u672b\u3084\u6708\u521d\u306e\u65e5\u4ed8\u3092\u81ea\u52d5\u3067\u5165\u529b\u3059\u308b\u95a2\u6570\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u4f8b\u3048\u3070\u8acb\u6c42\u66f8\u30fb\u7d0d\u54c1\u66f8\u30fb\u9818\u53ce\u66f8\u30fb\u7533\u8acb\u66f8\u30fb\u8a3c\u660e\u66f8\u306a\u3069\u3001\u65e5\u4ed8\u306e\u8a18\u8f09\u304c\u5fc5\u9808\u306e\u66f8\u985e\u4f5c\u6210\u6642\u306b\u5f79\u7acb\u3064\u3067\u3057\u3087\u3046\u3002\u95a2\u6570\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u624b\u5165\u529b [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":5703,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"vkexunit_cta_each_option":"","footnotes":""},"categories":[15],"tags":[],"class_list":["post-4527","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-15"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/onechat.jp\/blog\/wp-json\/wp\/v2\/posts\/4527","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onechat.jp\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onechat.jp\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onechat.jp\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/onechat.jp\/blog\/wp-json\/wp\/v2\/comments?post=4527"}],"version-history":[{"count":2,"href":"https:\/\/onechat.jp\/blog\/wp-json\/wp\/v2\/posts\/4527\/revisions"}],"predecessor-version":[{"id":4533,"href":"https:\/\/onechat.jp\/blog\/wp-json\/wp\/v2\/posts\/4527\/revisions\/4533"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onechat.jp\/blog\/wp-json\/wp\/v2\/media\/5703"}],"wp:attachment":[{"href":"https:\/\/onechat.jp\/blog\/wp-json\/wp\/v2\/media?parent=4527"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onechat.jp\/blog\/wp-json\/wp\/v2\/categories?post=4527"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onechat.jp\/blog\/wp-json\/wp\/v2\/tags?post=4527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}