{"id":1541,"date":"2016-07-15T00:17:48","date_gmt":"2016-07-14T15:17:48","guid":{"rendered":"http:\/\/stuffy.dip.jp\/wordpress\/?p=1541"},"modified":"2017-05-29T16:16:09","modified_gmt":"2017-05-29T07:16:09","slug":"calc-ages-by-excel","status":"publish","type":"post","link":"https:\/\/www.stuffy.site\/wordpress\/?p=1541","title":{"rendered":"Excel\u3067\u5e74\u9f62\u3092\u8a08\u7b97"},"content":{"rendered":"<p>Excel\u306e\u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306f\u8272\u3005\u3042\u3063\u3066\u899a\u3048\u308b\u306e\u306f\u5927\u5909\u3067\u3059\u304c\u3001\u30bb\u30eb\u9078\u629e\u3057\u3066[Ctrl] + [1] \u304b\u3089\u30bb\u30eb\u306e\u66f8\u5f0f\u8a2d\u5b9a\u3092\u958b\u3044\u3066\u3001[\u8868\u793a\u5f62\u5f0f]\u30bf\u30d6 \u2192 [\u65e5\u4ed8]\u3092\u78ba\u8a8d\u3059\u308b\u3068\u826f\u3044\u3067\u3059\u3002<\/p>\n<p>\u4f8b\uff09<br \/>\n\u3010\u897f\u66a6\u30111971\/8\/13<br \/>\n\u3010\u548c\u66a6\u3011S.46.8.13<\/p>\n<p>\u5e74\u9f62\u306fDATEDIF\u95a2\u6570\u3092\u4f7f\u3063\u3066\u4ee5\u4e0b\u306e\u5f0f\u3067\u8a08\u7b97\u3067\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">A2=1971\/8\/13\r\nB2=DATEDIF($A2,TODAY(),\"Y\")<\/pre>\n<p>\u7b2c3\u5f15\u6570\u306f\u3001\u958b\u59cb\u65e5($A2)\u304b\u3089\u7d42\u4e86\u65e5(TODAY())\u307e\u3067\u306e\u671f\u9593\u3092\u5e74\u6570\u3067\u8868\u793a\u3059\u308b\u30aa\u30d7\u30b7\u30e7\u30f3\u3067\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.stuffy.site\/wordpress\/wp-content\/uploads\/2016\/07\/datedif.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1536\" src=\"https:\/\/www.stuffy.site\/wordpress\/wp-content\/uploads\/2016\/07\/datedif.png\" alt=\"datedif\" width=\"591\" height=\"403\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel\u306e\u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306f\u8272\u3005\u3042\u3063\u3066\u899a\u3048\u308b\u306e\u306f\u5927\u5909\u3067\u3059\u304c\u3001\u30bb\u30eb\u9078\u629e\u3057\u3066[Ctrl] + [1] \u304b\u3089\u30bb\u30eb\u306e\u66f8\u5f0f\u8a2d\u5b9a\u3092\u958b\u3044\u3066\u3001[\u8868\u793a\u5f62\u5f0f]\u30bf\u30d6 \u2192 [\u65e5\u4ed8]\u3092\u78ba\u8a8d\u3059\u308b\u3068\u826f\u3044\u3067\u3059\u3002 \u4f8b\uff09 \u3010\u897f\u66a6\u30111971\/8\/13 \u3010\u548c &hellip; <a href=\"https:\/\/www.stuffy.site\/wordpress\/?p=1541\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">Excel\u3067\u5e74\u9f62\u3092\u8a08\u7b97<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[67,5],"tags":[],"class_list":["post-1541","post","type-post","status-publish","format-standard","hentry","category-excel","category-software"],"_links":{"self":[{"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1541","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1541"}],"version-history":[{"count":3,"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1541\/revisions"}],"predecessor-version":[{"id":1544,"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1541\/revisions\/1544"}],"wp:attachment":[{"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stuffy.site\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}