{"id":741,"date":"2014-01-23T00:43:52","date_gmt":"2014-01-22T23:43:52","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=741"},"modified":"2020-06-18T15:56:58","modified_gmt":"2020-06-18T13:56:58","slug":"excel-datumkezeles","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/","title":{"rendered":"Egy\u00e9b \u00e9rdekess\u00e9gek az Excel d\u00e1tumkezel\u00e9s kapcs\u00e1n"},"content":{"rendered":"<p>Az Excel d\u00e1tumkezel\u00e9s gyakran okoz riadalmat: egy d\u00e1tum helyett egy sz\u00e1m jelenik meg, pl.\u00a041615. Kor\u00e1bban volt m\u00e1r r\u00f3la sz\u00f3, hogy a\u00a0<a title=\"Tudtad, hogy a d\u00e1tumok sz\u00e1mok?\" href=\"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/\" target=\"_blank\" rel=\"noopener noreferrer\">d\u00e1tumok sz\u00e1mok<\/a>, \u00e9s a\u00a0form\u00e1zatlan cell\u00e1k felismerik \u00e9s kezelik a d\u00e1tum form\u00e1tumokat.<\/p>\n<p>Az, hogy a d\u00e1tumok sz\u00e1mok, 3 tov\u00e1bbi izgalmas k\u00e9rd\u00e9st is felvet.<!--more--><\/p>\n<h3>1. Melyik az els\u0151 \u00e9s utols\u00f3 d\u00e1tum, amit megadhatsz az Excelben?<\/h3>\n<p>Az 1-es sz\u00e1m az 1900. janu\u00e1r 1-hez tartozik. B\u00e1r az els\u0151 d\u00e1tum igazib\u00f3l a nulla, ami 1900.01.00<\/p>\n<p>Az utols\u00f3 d\u00e1tum pedig 9999.12.31, ami sorsz\u00e1m szerint\u00a02 958 465.<\/p>\n<p>Ezzel a k\u00f6zel 3 milli\u00f3 d\u00e1tummal egyszer\u0171bb sz\u00e1m\u00edt\u00e1sokat el tud v\u00e9gezni a program, valamint mindegyik napr\u00f3l tudja, hogy a h\u00e9t mely napj\u00e1ra esett, \u00edgy b\u00e1tran k\u00e9sz\u00edthetsz <a href=\"https:\/\/sosexcel.com\/exceltippek\/excel-naptar-2018-oroknaptar\/\" target=\"_blank\" rel=\"noopener noreferrer\">\u00f6r\u00f6knapt\u00e1rat<\/a> is.<\/p>\n<p>Term\u00e9szetesen sz\u00f6vegk\u00e9nt b\u00e1rmilyen kor\u00e1bbi vagy k\u00e9s\u0151bbi d\u00e1tumot r\u00f6gz\u00edthetsz, de azokkal nem tudsz eltelt napokat sz\u00e1molni.<\/p>\n<h3>2. Excel d\u00e1tumkezel\u00e9s: mi a helyzet a tizedesjegyekkel?<\/h3>\n<p>Mivel a k\u00f3dol\u00e1sban 1 = 1 nap = 24 \u00f3ra, ez\u00e9rt 0,5 = 12 \u00f3ra, 0,75 = 18:00 \u00e9s 1\/3 = 0,33333 = 8 \u00f3ra.<\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/clock-id\u0151.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignleft wp-image-2285\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/clock-id\u0151.jpg\" alt=\"Excel d\u00e1tumkezel\u00e9s rejt\u00e9lyes eseteinek megold\u00e1sa\" width=\"360\" height=\"225\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/clock-id\u0151.jpg 800w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/clock-id\u0151-300x188.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/clock-id\u0151-660x413.jpg 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/clock-id\u0151-240x150.jpg 240w\" sizes=\"(max-width: 360px) 100vw, 360px\" \/><\/a>A kerek\u00edt\u00e9ssel \u00f3vatosan kell b\u00e1nni, mivel 0,001 =\u00a01 perc 26 m\u00e1sodperc.<\/p>\n<p>Egy nap 86.400 m\u00e1sodperc, \u00edgy egy m\u00e1sodperc\u00a0\u00e9rt\u00e9ke (1\/86400, azaz) 0,0000116.<\/p>\n<p>Ebb\u0151l ad\u00f3dik, hogy nem csak a napokkal, hanem az id\u0151pontokkal is lehet sz\u00e1molni. P\u00e9ld\u00e1ul a <a title=\"Munkaid\u0151 nyilv\u00e1ntart\u00e1s \u00e9s munkaid\u0151 sz\u00e1m\u00edt\u00e1s Excellel\" href=\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/\" target=\"_blank\" rel=\"noopener noreferrer\">munkaid\u0151-nyilv\u00e1ntart\u00e1sban<\/a> kivon\u00e1ssal kisz\u00e1m\u00edthatod a let\u00f6lt\u00f6tt\u00a0munkaid\u0151t: 17:00-8:30-0:30 = 8:00<\/p>\n<p><strong>Tipp:<\/strong> A pontos id\u0151t kell r\u00f6gz\u00edtened egy cell\u00e1ban? Nyomd meg a <strong>Ctrl Shift .<\/strong> (pont) gombokat, \u00e9s m\u00e1ris beker\u00fcl az aktu\u00e1lis id\u0151pont a cell\u00e1ba.<\/p>\n<h3>3. Hogyan lehet a 24:00 vagy t\u00f6bb \u00f3r\u00e1t megform\u00e1zni?<\/h3>\n<p>Mivel azonban az id\u0151 form\u00e1tumn\u00e1l nem szerepel a nap (vagyis az eg\u00e9sz r\u00e9sz), \u00edgy t\u00f6bb \u00f3r\u00e1n\u00e1l mindig csak az eg\u00e9sz r\u00e9sz (24 \u00f3ra) n\u00e9lk\u00fcl l\u00e1tod az eredm\u00e9nyt. Ez p\u00e9ld\u00e1ul a <a href=\"https:\/\/sosexcel.com\/exceltippek\/munkaido-nyilvantartas-es-munkaido-szamitas-excellel\/\" target=\"_blank\" rel=\"noopener noreferrer\">munkaid\u0151 \u00f6sszes\u00edt\u00e9s\u00e9n\u00e9l<\/a> okozhat gondot.<\/p>\n<p>Ha szeretn\u00e9d m\u00e9gis a pontos \u00f3rasz\u00e1mot l\u00e1tni, akkor\u00a0Egy\u00e9ni form\u00e1tumot kell haszn\u00e1lnod. A Cella form\u00e1z\u00e1s ablakban \u00edrd \u00e1t az<span style=\"font-size: 16px; line-height: 1.714285714;\">\u00a0\u00f3:pp k\u00f3dot a<\/span>\u00a0k\u00f6vetkez\u0151re: [\u00f3]:pp<\/p>\n<h2>K\u00e9rd\u00e9sed van az Excel d\u00e1tumokr\u00f3l?<\/h2>\n<p>Ha szeretn\u00e9l konkr\u00e9t gyakorl\u00f3 feladatokat,\u00a0<strong>\u00e9s szem\u00e9lyre szabott tippeket kapni,\u00a0<\/strong>akkor gyere el egy\u00a0<a href=\"http:\/\/exceltitok.hu\/arak\" target=\"_blank\" rel=\"noopener noreferrer\">egy\u00e9ni Excel tanfolyam<\/a>ra! Ha ink\u00e1bb egy t\u00e1mogat\u00f3 k\u00f6z\u00f6ss\u00e9get szeretn\u00e9l, ahol b\u00e1rmikor felteheted a k\u00e9rd\u00e9seid, akkor csatlakozz az\u00a0<a href=\"http:\/\/exceltitok.hu\/vip-klub\/\" target=\"_blank\" rel=\"noopener noreferrer\">ExcelTitok VIP Klubba<\/a>!<\/p>\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><a href=\"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/\">Hogyan lehet a d\u00e1tumokat gyorsan be\u00edrni?<\/a><\/p><\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><a href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-irj-kepleteket-az-excelben\/\">Hogyan \u00edrj k\u00e9pleteket az Excelben?<\/a><\/p><\/blockquote>\n\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/b3-TD_O5mRE\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n\n","protected":false},"excerpt":{"rendered":"<p>Az Excel d\u00e1tumkezel\u00e9s gyakran okoz riadalmat: egy d\u00e1tum helyett egy sz\u00e1m jelenik meg, pl.\u00a041615. Kor\u00e1bban volt m\u00e1r r\u00f3la sz\u00f3, hogy a\u00a0d\u00e1tumok sz\u00e1mok, \u00e9s a\u00a0form\u00e1zatlan cell\u00e1k felismerik \u00e9s kezelik a d\u00e1tum form\u00e1tumokat. Az, hogy a d\u00e1tumok sz\u00e1mok, 3 tov\u00e1bbi izgalmas k\u00e9rd\u00e9st is felvet.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[27,8],"class_list":["post-741","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek","tag-billentyukombinacio","tag-datum"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Egy\u00e9b \u00e9rdekess\u00e9gek az Excel d\u00e1tumkezel\u00e9s kapcs\u00e1n - ExcelTitok.hu<\/title>\n<meta name=\"description\" content=\"Az Excel d\u00e1tumkezel\u00e9s gyakran okoz riadalmat: pl ha d\u00e1tum helyett sz\u00e1m jelenik meg, vagy ford\u00edtva. A d\u00e1tumok sz\u00e1mok, ami izgalmas k\u00e9rd\u00e9seket is felvet.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Egy\u00e9b \u00e9rdekess\u00e9gek az Excel d\u00e1tumkezel\u00e9s kapcs\u00e1n - ExcelTitok.hu\" \/>\n<meta property=\"og:description\" content=\"Az Excel d\u00e1tumkezel\u00e9s gyakran okoz riadalmat: pl ha d\u00e1tum helyett sz\u00e1m jelenik meg, vagy ford\u00edtva. A d\u00e1tumok sz\u00e1mok, ami izgalmas k\u00e9rd\u00e9seket is felvet.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/bernadett.koros\" \/>\n<meta property=\"article:published_time\" content=\"2014-01-22T23:43:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-06-18T13:56:58+00:00\" \/>\n<meta name=\"author\" content=\"Bernadett\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bernadett\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/excel-datumkezeles\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/excel-datumkezeles\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Egy\u00e9b \u00e9rdekess\u00e9gek az Excel d\u00e1tumkezel\u00e9s kapcs\u00e1n\",\"datePublished\":\"2014-01-22T23:43:52+00:00\",\"dateModified\":\"2020-06-18T13:56:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/excel-datumkezeles\\\/\"},\"wordCount\":462,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"keywords\":[\"billenty\u0171kombin\u00e1ci\u00f3\",\"d\u00e1tum\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/excel-datumkezeles\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/excel-datumkezeles\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/excel-datumkezeles\\\/\",\"name\":\"Egy\u00e9b \u00e9rdekess\u00e9gek az Excel d\u00e1tumkezel\u00e9s kapcs\u00e1n - ExcelTitok.hu\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"datePublished\":\"2014-01-22T23:43:52+00:00\",\"dateModified\":\"2020-06-18T13:56:58+00:00\",\"description\":\"Az Excel d\u00e1tumkezel\u00e9s gyakran okoz riadalmat: pl ha d\u00e1tum helyett sz\u00e1m jelenik meg, vagy ford\u00edtva. A d\u00e1tumok sz\u00e1mok, ami izgalmas k\u00e9rd\u00e9seket is felvet.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/excel-datumkezeles\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/excel-datumkezeles\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/excel-datumkezeles\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Egy\u00e9b \u00e9rdekess\u00e9gek az Excel d\u00e1tumkezel\u00e9s kapcs\u00e1n\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"description\":\"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!\",\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"width\":600,\"height\":133,\"caption\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\",\"name\":\"Bernadett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"caption\":\"Bernadett\"},\"description\":\"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.\",\"sameAs\":[\"http:\\\/\\\/exceltitok.hu\\\/\",\"https:\\\/\\\/www.facebook.com\\\/bernadett.koros\"],\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/author\\\/sos-excel\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Egy\u00e9b \u00e9rdekess\u00e9gek az Excel d\u00e1tumkezel\u00e9s kapcs\u00e1n - ExcelTitok.hu","description":"Az Excel d\u00e1tumkezel\u00e9s gyakran okoz riadalmat: pl ha d\u00e1tum helyett sz\u00e1m jelenik meg, vagy ford\u00edtva. A d\u00e1tumok sz\u00e1mok, ami izgalmas k\u00e9rd\u00e9seket is felvet.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/","og_locale":"hu_HU","og_type":"article","og_title":"Egy\u00e9b \u00e9rdekess\u00e9gek az Excel d\u00e1tumkezel\u00e9s kapcs\u00e1n - ExcelTitok.hu","og_description":"Az Excel d\u00e1tumkezel\u00e9s gyakran okoz riadalmat: pl ha d\u00e1tum helyett sz\u00e1m jelenik meg, vagy ford\u00edtva. A d\u00e1tumok sz\u00e1mok, ami izgalmas k\u00e9rd\u00e9seket is felvet.","og_url":"https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2014-01-22T23:43:52+00:00","article_modified_time":"2020-06-18T13:56:58+00:00","author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"2 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Egy\u00e9b \u00e9rdekess\u00e9gek az Excel d\u00e1tumkezel\u00e9s kapcs\u00e1n","datePublished":"2014-01-22T23:43:52+00:00","dateModified":"2020-06-18T13:56:58+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/"},"wordCount":462,"commentCount":1,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"keywords":["billenty\u0171kombin\u00e1ci\u00f3","d\u00e1tum"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/","url":"https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/","name":"Egy\u00e9b \u00e9rdekess\u00e9gek az Excel d\u00e1tumkezel\u00e9s kapcs\u00e1n - ExcelTitok.hu","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"datePublished":"2014-01-22T23:43:52+00:00","dateModified":"2020-06-18T13:56:58+00:00","description":"Az Excel d\u00e1tumkezel\u00e9s gyakran okoz riadalmat: pl ha d\u00e1tum helyett sz\u00e1m jelenik meg, vagy ford\u00edtva. A d\u00e1tumok sz\u00e1mok, ami izgalmas k\u00e9rd\u00e9seket is felvet.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-datumkezeles\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Egy\u00e9b \u00e9rdekess\u00e9gek az Excel d\u00e1tumkezel\u00e9s kapcs\u00e1n"}]},{"@type":"WebSite","@id":"https:\/\/sosexcel.com\/exceltippek\/#website","url":"https:\/\/sosexcel.com\/exceltippek\/","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!","publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"},{"@type":"Organization","@id":"https:\/\/sosexcel.com\/exceltippek\/#organization","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","url":"https:\/\/sosexcel.com\/exceltippek\/","logo":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","width":600,"height":133,"caption":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b","name":"Bernadett","image":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","caption":"Bernadett"},"description":"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.","sameAs":["http:\/\/exceltitok.hu\/","https:\/\/www.facebook.com\/bernadett.koros"],"url":"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/"}]}},"_links":{"self":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/comments?post=741"}],"version-history":[{"count":13,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/741\/revisions"}],"predecessor-version":[{"id":8794,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/741\/revisions\/8794"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}