{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkuku81kuku81.hatenablog.com%2Fentry%2F2026%2F02%2F07_Excel_VBA_how_to_use_DateAdd%2528%2529\" title=\"\u3010Excel\u30de\u30af\u30ed\u5165\u9580\u3011DateAdd()\u3067\u65e5\u4ed8\u64cd\u4f5c - Django Girls and Boys \u5099\u5fd8\u9332\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://kuku81kuku81.hatenablog.com/entry/2026/02/07_Excel_VBA_how_to_use_DateAdd%28%29","type":"rich","version":"1.0","published":"2026-02-07 19:00:00","blog_url":"https://kuku81kuku81.hatenablog.com/","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/k/kuku81kuku81/20220605/20220605115219.png","categories":["Excel","VBA","\u30de\u30af\u30ed"],"height":"190","width":"100%","provider_url":"https://hatena.blog","title":"\u3010Excel\u30de\u30af\u30ed\u5165\u9580\u3011DateAdd()\u3067\u65e5\u4ed8\u64cd\u4f5c","description":"\u65e5\u4ed8\u51e6\u7406\u306f\u3001Excel\u30de\u30af\u30ed\u3067\u6700\u3082\u691c\u7d22\u3055\u308c\u308b\u30b8\u30e3\u30f3\u30eb\u306e1\u3064\u3067\u3059\u3002 \u305d\u306e\u4e2d\u3067\u3082\u8d85\u5b9a\u756a\u306a\u306e\u304c DateAdd()\u3002 \ud83d\udd39 DateAdd()\u3068\u306f\uff1f \u66f8\u5f0f DateAdd(\u9593\u9694, \u6570\u5024, \u65e5\u4ed8) \u9593\u9694\u306e\u6307\u5b9a\u4f8b \u6307\u5b9a \u610f\u5473 \"d\" \u65e5 \"m\" \u6708 \"yyyy\" \u5e74 \"h\" \u6642 \"n\" \u5206 \ud83d\udca1 \u57fa\u672c\u4f8b\uff1a\u25cb\u65e5\u5f8c\u3092\u6c42\u3081\u308b Debug.Print DateAdd(\"d\", 7, Date) \ud83d\udc49 \u4eca\u65e5\u304b\u30897\u65e5\u5f8c\u3002 \ud83d\udca1 \u6708\u672b\u51e6\u7406\u3067\u8d85\u4fbf\u5229\u306a\u4f8b \u6765\u6708\u306e\u6708\u672b Dim lastDay As DatelastDay = DateAdd(\"d\", -1, DateAdd(\"m\", 1, DateSerial(Year(Date\u2026","blog_title":"Django Girls and Boys \u5099\u5fd8\u9332","provider_name":"Hatena Blog","author_name":"kuku81kuku81","author_url":"https://blog.hatena.ne.jp/kuku81kuku81/"}