{"id":283,"date":"2013-08-29T12:42:07","date_gmt":"2013-08-29T10:42:07","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=283"},"modified":"2020-06-18T09:14:05","modified_gmt":"2020-06-18T07:14:05","slug":"tudtad-hogy-a-datumok-szamok","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/","title":{"rendered":"Tudtad, hogy a d\u00e1tumok sz\u00e1mok?"},"content":{"rendered":"<p>Az\u00e9rt, hogy az Excel egys\u00e9gesen tudja kezelni a d\u00e1tumokat, sorsz\u00e1mk\u00e9nt t\u00e1rolja azokat.\u00a0Alap\u00e9rtelmez\u00e9s szerint 1900. janu\u00e1r 1. megfelel\u0151je az 1-es sorsz\u00e1m, m\u00edg p\u00e9ld\u00e1ul a 2013. janu\u00e1r 1. naphoz 41275 tartozik. (<a title=\"Egy\u00e9b \u00e9rdekess\u00e9gek a d\u00e1tumokkal kapcsolatban\" href=\"https:\/\/sosexcel.com\/exceltippek\/egyeb-erdekessegek-datumokkal-kapcsolatban\/\" target=\"_blank\" rel=\"noopener noreferrer\">Melyik az utols\u00f3 nap, amit megadhatsz az Excelben?<\/a>)<\/p>\n<h2>Hov\u00e1 lett a d\u00e1tum?<\/h2>\n<p>Biztos j\u00e1rt\u00e1l m\u00e1r \u00fagy, hogy egy sz\u00e1mot beg\u00e9pelve d\u00e1tum jelent meg. Vagy ford\u00edtva: a be\u00edrt id\u0151pont elvesztette a form\u00e1tum\u00e1t, \u00e9s egy sz\u00e1m jelent meg.<!--more--><\/p>\n<figure id=\"attachment_284\" aria-describedby=\"caption-attachment-284\" style=\"width: 304px\" class=\"wp-caption alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/datum-szamformatum.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-284 \" style=\"border: 1px solid grey;\" title=\"A Sz\u00e1mform\u00e1tumn\u00e1l adhatod meg, hogyan jelenjen meg a d\u00e1tum.\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/datum-szamformatum.jpg\" alt=\"A Cellaform\u00e1z\u00e1s ablak Sz\u00e1mform\u00e1tum f\u00fcl\u00f6n \u00e1ll\u00edthatod be a d\u00e1tumok megjelen\u00e9si m\u00f3dj\u00e1t.\" width=\"304\" height=\"226\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/datum-szamformatum.jpg 304w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/datum-szamformatum-300x223.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/datum-szamformatum-240x178.jpg 240w\" sizes=\"(max-width: 304px) 100vw, 304px\" \/><\/a><figcaption id=\"caption-attachment-284\" class=\"wp-caption-text\">T\u00f6bb fajta d\u00e1tum megjelen\u00edt\u00e9sb\u0151l v\u00e1laszthatsz.<\/figcaption><\/figure>\n<p>Ilyenkor ne ess k\u00e9ts\u00e9gbe, hanem haszn\u00e1ld a megfelel\u0151 sz\u00e1mform\u00e1tumot!<\/p>\n<p>Nyisd meg a Cell\u00e1k form\u00e1z\u00e1sa ablakot, \u00e9s v\u00e1laszd a neked tetsz\u0151 megjelen\u00e9st, vagy alak\u00edtsd vissza sz\u00e1mm\u00e1 az \u00e9rt\u00e9ket.<\/p>\n<p><strong>A d\u00e1tumokat ak\u00e1r idegen nyelven is megjelen\u00edtheted<\/strong>\u00a0az egys\u00e9ges rendszernek k\u00f6sz\u00f6nhet\u0151en.\u00a0A form\u00e1tum alatt v\u00e1laszd ki a c\u00e9l nyelvet.<\/p>\n<h2>Hogyan sz\u00e1molj a d\u00e1tumokkal?<\/h2>\n<p>Mivel a d\u00e1tumok \u00e9s az id\u0151k sz\u00e1mok, ez\u00e9rt <strong>egyszer\u0171bb sz\u00e1m\u00edt\u00e1sokat is v\u00e9gezhetsz vel\u00fck: \u00f6sszead\u00e1st, kivon\u00e1st.<\/strong><\/p>\n<p>P\u00e9ld\u00e1ul ha az A2 cell\u00e1ban d\u00e1tum szerepel, akkor az azt k\u00f6vet\u0151 nap =A2+1<br \/>A 8 napos fizet\u00e9si hat\u00e1rid\u0151 =A2+8 lesz.<\/p>\n<p>Ugyan\u00edgy sima kivon\u00e1ssal kisz\u00e1m\u00edthat\u00f3 2 id\u0151pont k\u00f6z\u00f6tt az eltelt napok sz\u00e1ma, p\u00e9ld\u00e1ul az, hogy h\u00e1ny napja nem fizett\u00e9k ki az adott sz\u00e1ml\u00e1t. Vagy ha r\u00f6gz\u00edted a sz\u00fclet\u00e9snapodat \u00e9s az aktu\u00e1lis napot, akkor kisz\u00e1m\u00edthatod, hogy \u00e9ppen h\u00e1ny napos vagy.<\/p>\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/GKsY6pwCWbY\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n\n\n<h2 class=\"wp-block-heading\">Tudj meg t\u00f6bbet a d\u00e1tumokr\u00f3l<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u00c9rdemes megtanulnod a <a href=\"https:\/\/sosexcel.com\/exceltippek\/datumok-gyors-bevitele\/\" target=\"_blank\" rel=\"noreferrer noopener\">d\u00e1tumok gyors bevitel\u00e9t<\/a>. Tov\u00e1bbi <a href=\"https:\/\/sosexcel.com\/exceltippek\/egyeb-erdekessegek-datumokkal-kapcsolatban\/\" target=\"_blank\" rel=\"noreferrer noopener\">\u00e9rdekess\u00e9geket a d\u00e1tumokr\u00f3l itt<\/a>&nbsp;tal\u00e1lsz.<\/p>\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\/mai-datum\/\">Melyik f\u00fcggv\u00e9ny mutatja a mai d\u00e1tumot?<\/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\/excel-naptar-2018-oroknaptar\/\">Excel napt\u00e1r: 2018 vagy \u00f6r\u00f6knapt\u00e1r<\/a><\/p><\/blockquote>\n\n\n\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","protected":false},"excerpt":{"rendered":"<p>Az\u00e9rt, hogy az Excel egys\u00e9gesen tudja kezelni a d\u00e1tumokat, sorsz\u00e1mk\u00e9nt t\u00e1rolja azokat.\u00a0Alap\u00e9rtelmez\u00e9s szerint 1900. janu\u00e1r 1. megfelel\u0151je az 1-es sorsz\u00e1m, m\u00edg p\u00e9ld\u00e1ul a 2013. janu\u00e1r 1. naphoz 41275 tartozik. (Melyik az utols\u00f3 nap, amit megadhatsz az Excelben?) Hov\u00e1 lett a d\u00e1tum? Biztos j\u00e1rt\u00e1l m\u00e1r \u00fagy, hogy egy sz\u00e1mot beg\u00e9pelve d\u00e1tum jelent meg. Vagy ford\u00edtva: a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3720,"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":[8,9],"class_list":["post-283","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-datum","tag-formatum"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Tudtad, hogy a d\u00e1tumok sz\u00e1mok? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"Hov\u00e1 lett a d\u00e1tum? Biztos j\u00e1rt\u00e1l m\u00e1r \u00fagy, hogy a d\u00e1tum elvesztette a d\u00e1tum form\u00e1tum\u00e1t, \u00e9s egy sz\u00e1m jelent meg. Vagy ford\u00edtva: sz\u00e1m helyett d\u00e1tum lett.\" \/>\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\/tudtad-hogy-a-datumok-szamok\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tudtad, hogy a d\u00e1tumok sz\u00e1mok? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Hov\u00e1 lett a d\u00e1tum? Biztos j\u00e1rt\u00e1l m\u00e1r \u00fagy, hogy a d\u00e1tum elvesztette a d\u00e1tum form\u00e1tum\u00e1t, \u00e9s egy sz\u00e1m jelent meg. Vagy ford\u00edtva: sz\u00e1m helyett d\u00e1tum lett.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/\" \/>\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=\"2013-08-29T10:42:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-06-18T07:14:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"850\" \/>\n\t<meta property=\"og:image:height\" content=\"266\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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\\\/tudtad-hogy-a-datumok-szamok\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tudtad-hogy-a-datumok-szamok\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Tudtad, hogy a d\u00e1tumok sz\u00e1mok?\",\"datePublished\":\"2013-08-29T10:42:07+00:00\",\"dateModified\":\"2020-06-18T07:14:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tudtad-hogy-a-datumok-szamok\\\/\"},\"wordCount\":348,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tudtad-hogy-a-datumok-szamok\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/calendar-numbers-napok-szerint.jpg\",\"keywords\":[\"d\u00e1tum\",\"form\u00e1tum\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tudtad-hogy-a-datumok-szamok\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tudtad-hogy-a-datumok-szamok\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tudtad-hogy-a-datumok-szamok\\\/\",\"name\":\"Tudtad, hogy a d\u00e1tumok sz\u00e1mok? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tudtad-hogy-a-datumok-szamok\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tudtad-hogy-a-datumok-szamok\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/calendar-numbers-napok-szerint.jpg\",\"datePublished\":\"2013-08-29T10:42:07+00:00\",\"dateModified\":\"2020-06-18T07:14:05+00:00\",\"description\":\"Hov\u00e1 lett a d\u00e1tum? Biztos j\u00e1rt\u00e1l m\u00e1r \u00fagy, hogy a d\u00e1tum elvesztette a d\u00e1tum form\u00e1tum\u00e1t, \u00e9s egy sz\u00e1m jelent meg. Vagy ford\u00edtva: sz\u00e1m helyett d\u00e1tum lett.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tudtad-hogy-a-datumok-szamok\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tudtad-hogy-a-datumok-szamok\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tudtad-hogy-a-datumok-szamok\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/calendar-numbers-napok-szerint.jpg\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2016\\\/07\\\/calendar-numbers-napok-szerint.jpg\",\"width\":850,\"height\":266},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tudtad-hogy-a-datumok-szamok\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tudtad, hogy a d\u00e1tumok sz\u00e1mok?\"}]},{\"@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":"Tudtad, hogy a d\u00e1tumok sz\u00e1mok? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"Hov\u00e1 lett a d\u00e1tum? Biztos j\u00e1rt\u00e1l m\u00e1r \u00fagy, hogy a d\u00e1tum elvesztette a d\u00e1tum form\u00e1tum\u00e1t, \u00e9s egy sz\u00e1m jelent meg. Vagy ford\u00edtva: sz\u00e1m helyett d\u00e1tum lett.","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\/tudtad-hogy-a-datumok-szamok\/","og_locale":"hu_HU","og_type":"article","og_title":"Tudtad, hogy a d\u00e1tumok sz\u00e1mok? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Hov\u00e1 lett a d\u00e1tum? Biztos j\u00e1rt\u00e1l m\u00e1r \u00fagy, hogy a d\u00e1tum elvesztette a d\u00e1tum form\u00e1tum\u00e1t, \u00e9s egy sz\u00e1m jelent meg. Vagy ford\u00edtva: sz\u00e1m helyett d\u00e1tum lett.","og_url":"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2013-08-29T10:42:07+00:00","article_modified_time":"2020-06-18T07:14:05+00:00","og_image":[{"width":850,"height":266,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg","type":"image\/jpeg"}],"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\/tudtad-hogy-a-datumok-szamok\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Tudtad, hogy a d\u00e1tumok sz\u00e1mok?","datePublished":"2013-08-29T10:42:07+00:00","dateModified":"2020-06-18T07:14:05+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/"},"wordCount":348,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg","keywords":["d\u00e1tum","form\u00e1tum"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/","url":"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/","name":"Tudtad, hogy a d\u00e1tumok sz\u00e1mok? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg","datePublished":"2013-08-29T10:42:07+00:00","dateModified":"2020-06-18T07:14:05+00:00","description":"Hov\u00e1 lett a d\u00e1tum? Biztos j\u00e1rt\u00e1l m\u00e1r \u00fagy, hogy a d\u00e1tum elvesztette a d\u00e1tum form\u00e1tum\u00e1t, \u00e9s egy sz\u00e1m jelent meg. Vagy ford\u00edtva: sz\u00e1m helyett d\u00e1tum lett.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/07\/calendar-numbers-napok-szerint.jpg","width":850,"height":266},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Tudtad, hogy a d\u00e1tumok sz\u00e1mok?"}]},{"@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\/283","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=283"}],"version-history":[{"count":19,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/283\/revisions"}],"predecessor-version":[{"id":8790,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/283\/revisions\/8790"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/3720"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}