{"id":9381,"date":"2017-03-23T11:10:59","date_gmt":"2017-03-23T10:10:59","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=9381"},"modified":"2017-03-23T11:34:03","modified_gmt":"2017-03-23T10:34:03","slug":"excel-leeftijd-in-jaar-en-maand","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/excel-leeftijd-in-jaar-en-maand\/","title":{"rendered":"Excel: leeftijd in jaar en maand"},"content":{"rendered":"<p>V. Kan ik de leeftijd laten berekenen \/ weergeven in jaren en maanden?<\/p>\n<p>A. Ja, dat kan.<\/p>\n<ul>\n<li>Als de geboortedatum in A1 staat, kan je de leeftijd berekenen met\u00c2\u00a0=INT((TODAY()-A1)\/365,25)<\/li>\n<li>Je kan jaren en maanden hebben met<br \/>\n=TODAY()-A1<br \/>\nopgemaakt als j &#8220;j&#8221; m &#8220;m&#8221; in celeigenschappen, aangepast.<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2012\/04\/leeftijd-in-j-en-m.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51131\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2012\/04\/leeftijd-in-j-en-m-300x148.png\" alt=\"\" width=\"300\" height=\"148\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2012\/04\/leeftijd-in-j-en-m-300x148.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2012\/04\/leeftijd-in-j-en-m-768x379.png 768w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2012\/04\/leeftijd-in-j-en-m-1024x506.png 1024w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2012\/04\/leeftijd-in-j-en-m.png 1275w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\nMaar&#8230; Excel begint de maanden te tellen vanaf 1 (tot 12), en niet vanaf 0 tot 11.<\/li>\n<li>Als dat een probleem is, kan je als volgt berekenen:<br \/>\n=INT((TODAY()-A1)\/365,25) &amp; &#8220;j &#8221; &amp; MONTH(TODAY()-A1)-1 &amp; &#8220;m&#8221;<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>V. Kan ik de leeftijd laten berekenen \/ weergeven in jaren en maanden? A. Ja, dat kan. Als de geboortedatum in A1 staat, kan je de leeftijd berekenen met\u00c2\u00a0=INT((TODAY()-A1)\/365,25) Je kan jaren en maanden hebben met =TODAY()-A1 opgemaakt als j &#8220;j&#8221; m &#8220;m&#8221; in celeigenschappen, aangepast. Maar&#8230; Excel begint de<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":138,"footnotes":""},"categories":[464,54,79,10],"tags":[],"class_list":["post-9381","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-odisee","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-02 21:30:17","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/9381","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=9381"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/9381\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=9381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=9381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=9381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}