{"description":"Excel\u3067\u3001\u300c\u751f\u5e74\u6708\u65e5\u3092\u793a\u30598\u6841\u306e\u6570\u5b57\u300d\u304b\u3089\u300c\u524d\u5e74\u5ea6\u672b\u6642\u70b9\u3067\u306e\u5e74\u9f62\u300d\u3092\u7b97\u51fa\u3057\u305f\u3044\u3002 \u6570\u5024\u3092\u65e5\u4ed8\u5f62\u5f0f\u306b\u3059\u308b\u300cDATEVALUE\u300d\u95a2\u6570\u3067\u6570\u5b578\u6841\u3092\u65e5\u4ed8\u306b\u5909\u63db\u3057\u3001\u65e5\u4ed8\u9593\u306e\u5e74\u6570\u3092\u51fa\u3059\u300cDATEDIF\u300d\u95a2\u6570\u3068\u7d44\u307f\u5408\u308f\u305b\u3066\u5e74\u5ea6\u672b\u5e74\u9f62\u3092\u51fa\u3057\u307e\u3057\u305f\u3002 1.DATEVALUE\u3067\u6570\u5b578\u6841\u3092\u65e5\u4ed8\u306b 2.DATEDIF\u3067\u65e5\u4ed8\u9593\u306e\u5e74\u9f62\u3092\u7b97\u51fa 19720818 1972/8/18 20210331 2021/3/31 48 A\u5217\uff1a\u751f\u5e74\u6708\u65e5\u3068\u5e74\u5ea6\u672b\u65e5\u4ed8\u306e\u6570\u5b578\u6841 B\u5217\uff1a\u65e5\u4ed8\u5f62\u5f0f\u306b\u5909\u63db C\u5217\uff1a\u524d\u5e74\u5ea6\u672b\u6642\u70b9\u306e\u5e74\u9f62 \u4f8b\u306b\u51fa\u3057\u3066\u3044\u308b\u300c1972\u5e748\u670818\u65e5\u300d\u306f\u3001\u4e2d\u5c45\u6b63\u5e83\u3055\u3093\u306e\u751f\u5e74\u6708\u65e5\u3067\u3059\u3002\u5143\u30d5\u30a1\u30a4\u30eb\u3067\u306f\u7236\u306e\u751f\u5e74\u6708\u65e5\u3092\u4f7f\u3063\u3066\u3044\u305f\u306e\u3067\u2026","author_name":"senyaitiya","provider_name":"Hatena Blog","type":"rich","published":"2021-04-18 18:31:48","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.senyaitiya.com%2Fentry%2F2021%2F04%2F18%2F183148\" title=\"\u3010Excel\u3011DATEVALUE\u3068DATEDIF\u3067\u751f\u5e74\u6708\u65e5\u306e\u6570\u5b578\u6841\u304b\u3089\u5e74\u5ea6\u672b\u5e74\u9f62\u3092\u7b97\u51fa - \u5343\u591c\u4e00\u591c\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"\u3010Excel\u3011DATEVALUE\u3068DATEDIF\u3067\u751f\u5e74\u6708\u65e5\u306e\u6570\u5b578\u6841\u304b\u3089\u5e74\u5ea6\u672b\u5e74\u9f62\u3092\u7b97\u51fa","author_url":"https://blog.hatena.ne.jp/senyaitiya/","blog_url":"https://www.senyaitiya.com/","height":"190","width":"100%","categories":["Excel"],"image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/s/senyaitiya/20210418/20210418181350.png","url":"https://www.senyaitiya.com/entry/2021/04/18/183148","provider_url":"https://hatena.blog","blog_title":"\u5343\u591c\u4e00\u591c","version":"1.0"}