{"id":351,"date":"2010-12-02T13:31:31","date_gmt":"2010-12-02T12:31:31","guid":{"rendered":"http:\/\/www.matjazev.net\/blog\/?p=351"},"modified":"2010-12-08T15:30:57","modified_gmt":"2010-12-08T14:30:57","slug":"posamezni-elementi-datuma-v-excelu","status":"publish","type":"post","link":"https:\/\/www.matjazev.net\/blog\/2010\/12\/02\/posamezni-elementi-datuma-v-excelu\/","title":{"rendered":"Posamezni elementi datuma v Excelu"},"content":{"rendered":"<p>Kot smo \u017ee spoznali, <a href=\"http:\/\/www.matjazev.net\/blog\/2010\/12\/02\/datumi-v-excelu\/\">vidi Excel datume kot naravna \u0161tevila<\/a>. Vpra\u0161anje, ki se pojavlja pa je, <strong>kako iz nekega datuma izlu\u0161\u010diti leto, mesec ali dan?<\/strong><\/p>\n<p>Re\u0161itvi tega problema so v Excel <strong>vgrajene tri funkcije YEAR<\/strong> (vrne leto), <strong>MONTH <\/strong>(vrne mesec) in <strong>DAY <\/strong>(vrne dan). Vsaka izmed funkcij sprejme en sam parameter in to je seveda datum za katerega nas dolo\u010den element zanima.<\/p>\n<p>\u010ce imamo torej v Excelu v celici D1 zapisan datum (12.3.2010), potem nam funkcije vrnejo slede\u010de:<br \/>\n<pre>=YEAR(D1)&nbsp;&nbsp; == 2010\n=MONTH(D1)&nbsp;&nbsp;== 3\n=DAY(D1)&nbsp;&nbsp;&nbsp;&nbsp;== 12\n<\/pre><\/p>\n<h3>Kaj pa kadar \u017eelimo iz posameznih elementov sestaviti datum?<\/h3>\n<p>Seveda ima Excel tudi za to, dokaj splo\u0161no zahtevo, ustrezno funkcijo in to je <strong>funkcija DATE<\/strong>. Funkcija sprejme tri parametre in to so seveda leto, mesec in dan. <span style=\"text-decoration: underline;\">Pozor, prvi parameter funkcije je leto, drugi mesec in tretji dan \u2013 torej ravno obratno, kot sicer datum zapi\u0161emo mi<\/span>.<br \/>\n<pre>=DATE(2010; 3; 12) == 12.3.2010\n<\/pre><br \/>\n<em>PS: Imena funkcij so seveda angle\u0161ke besede za posamezne elemente: day \u2013 dan, month \u2013 mesec, year \u2013 leto, date \u2013 datum!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kot smo \u017ee spoznali, vidi Excel datume kot naravna \u0161tevila. Vpra\u0161anje, ki se pojavlja pa je, kako iz nekega datuma izlu\u0161\u010diti leto, mesec ali dan? Re\u0161itvi tega problema so v Excel vgrajene tri funkcije YEAR (vrne leto), MONTH (vrne mesec) in DAY (vrne dan). Vsaka izmed funkcij sprejme en sam parameter in to je seveda &hellip; <a href=\"https:\/\/www.matjazev.net\/blog\/2010\/12\/02\/posamezni-elementi-datuma-v-excelu\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Posamezni elementi datuma v Excelu<\/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":[18,3],"tags":[32,14,61,30],"_links":{"self":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/351"}],"collection":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/comments?post=351"}],"version-history":[{"count":7,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/351\/revisions"}],"predecessor-version":[{"id":360,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/351\/revisions\/360"}],"wp:attachment":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/media?parent=351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/categories?post=351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/tags?post=351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}