{"id":2767,"date":"2020-04-10T15:28:34","date_gmt":"2020-04-10T15:28:34","guid":{"rendered":"https:\/\/wordpress-720855-2397626.cloudwaysapps.com\/?p=2767"},"modified":"2020-04-12T09:58:19","modified_gmt":"2020-04-12T09:58:19","slug":"what-you-should-know-about-dates-in-excel","status":"publish","type":"post","link":"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/","title":{"rendered":"What You Should Know About Dates in Excel"},"content":{"rendered":"\n<p>What&#8217;s up with dates and times in Excel? What is a serial number? And what does the date January 1st, 1900 have to do with it? Today, we&#8217;re de-mystifying dates in Excel. Let&#8217;s do this.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Dates in Excel: Serial numbers<\/h2>\n\n\n\n<p>In the video below, you can see what happens when you change the number format of a date to <em>General<\/em>.<\/p>\n\n\n\n<figure class=\"wp-block-video\"><video autoplay controls loop muted src=\"https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/Date-to-General-format-2.mp4\"><\/video><figcaption>What happens when you change a date to a <em>General <\/em>number format. You can see the underlying serial number that Excel uses behind the scenes.<\/figcaption><\/figure>\n\n\n\n<p>Weird, isn&#8217;t it? What you see here is the underlying number that Excel uses to represent the date. This number is called a serial number. But what does it mean? And why does 4\/10\/2020 become 43931? <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Serial numbers explained<\/h3>\n\n\n\n<p>Let us explain: 43931 is the number of days that have passed since 1\/1\/1900 to the date 4\/10\/2020. That&#8217;s how Excel saves dates. <\/p>\n\n\n\n<p>Knowing this helps us understand some of Excel&#8217;s behavior. For example, we can predict what will happen when you calculate <code>4\/10\/2020 + 1<\/code> in Excel. The result will be 43931 + 1 = 43932. And formatted as a date, you get 4\/11\/2020, one day later. In the same vein, <code>4\/10\/2020 - 7<\/code> will result in a serial number that is 7 days before 4\/10\/2020.<\/p>\n\n\n\n<p>So now you can use <a href=\"https:\/\/spreadsheetcenter.com\/functions\/today\/\">the TODAY function<\/a> to calculate yesterday&#8217;s date! It&#8217;s as simple as:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=TODAY() - 1<\/code><\/pre>\n\n\n\n<p class=\"has-background has-luminous-vivid-amber-background-color\"><strong>Note on dates before 1900 <\/strong>&#8211; You might be wondering what happens with dates <em>before <\/em>1\/1\/1900. You can try this for yourself: in a cell in Excel, type <em>1\/1\/1900<\/em>. You will see the number format change to <em>Date <\/em>automatically. If you then type <em>12\/31\/1899<\/em> (just one day earlier) into another cell, the number format won&#8217;t change. Excel does not recognize it as a date because it doesn&#8217;t have a serial number to use for it. The conclusion is that Excel just isn&#8217;t very useful for working with dates before the year 1900.<\/p>\n\n\n\n<p>This is not too difficult, right? It&#8217;s just Excel&#8217;s way of representing dates. However, it becomes more complicated when we add time as well.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Times<\/h2>\n\n\n\n<p>For dates <strong>with<\/strong> times, a fraction is added to the serial number to represent the time of the day. For example, 43931.00 is the serial number for the date-time combination of 4\/10\/2020 12:00 AM.<\/p>\n\n\n\n<p>The fraction is the percentage of the day that has passed at that time. So at 12 AM it&#8217;s .0000 and at 12PM it&#8217;s .5000. 1 AM is at the fraction 1\/24 (.041667).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Overview<\/h3>\n\n\n\n<p>Here&#8217;s an overview for some different times of the day and their corresponding fractions and decimals.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Time<\/th><th>Fraction<\/th><th>Decimal<\/th><\/tr><\/thead><tbody><tr><td>12 AM<\/td><td>0<\/td><td>.00000<\/td><\/tr><tr><td>1 AM<\/td><td>1\/24<\/td><td>.04167<\/td><\/tr><tr><td>2 AM<\/td><td>2\/24<\/td><td>.08333<\/td><\/tr><tr><td>12 PM<\/td><td>12\/24<\/td><td>.50000<\/td><\/tr><tr><td>12:01 AM<\/td><td>1\/24\/60<\/td><td>.000694<\/td><\/tr><tr><td>12:01:01 AM<\/td><td>1\/24\/60\/60<\/td><td>.000011574<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>You can use these fractions either on their own to only represent a time (0.5 for 12 PM) or combined with a whole number (43931.5 for 10\/4\/2020 12 PM) to represent both date <em>and <\/em>time.<\/p>\n\n\n\n<p>So by combining the whole number for the date and a fraction for the time, we can represent any date-time combination from 1900 up until now. Pretty cool, huh?<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Getting the current date and current time<\/h2>\n\n\n\n<p>Excel has functions that return the current date and time so you can use them in your worksheets. This can be handy for calculating ages based on date of birth. Or calculating how many days are left before a deadline.<\/p>\n\n\n\n<p>For the current date, you can use the TODAY function. <a href=\"https:\/\/spreadsheetcenter.com\/functions\/today\/\">We have a page about the Today function here.<\/a><\/p>\n\n\n\n<p>For the current date <strong>and <\/strong>time, there is the NOW function. <a href=\"https:\/\/spreadsheetcenter.com\/functions\/now\/\">We have a page about Now as well, with examples and explanations.<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Concluding<\/h2>\n\n\n\n<p>We hope you understand the inner workings of Excel a little better after reading this. If you have any more questions about date-shenanigans in Excel, let us know in the comments.<\/p>\n\n\n\n<p>Have a great day!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>What&#8217;s up with dates and times in Excel? What is a serial number? And what does the date January 1st, 1900 have to do with it? Today, we&#8217;re de-mystifying dates in Excel.<\/p>\n","protected":false},"author":1,"featured_media":2771,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"pmpro_default_level":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[1],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What You Should Know About Dates in Excel - Spreadsheet Center<\/title>\n<meta name=\"description\" content=\"Excel can do some funky things to your date and time values. We&#039;re looking at how Excel handles dates behind the scenes and how to solve common date issues.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What You Should Know About Dates in Excel - Spreadsheet Center\" \/>\n<meta property=\"og:description\" content=\"Excel can do some funky things to your date and time values. We&#039;re looking at how Excel handles dates behind the scenes and how to solve common date issues.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Spreadsheet Center\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-10T15:28:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-12T09:58:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"853\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Spreadsheet Center\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Spreadsheet Center\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/\"},\"author\":{\"name\":\"Spreadsheet Center\",\"@id\":\"https:\/\/spreadsheetcenter.com\/#\/schema\/person\/5b09281482bdf1753c0885ca6e18fff1\"},\"headline\":\"What You Should Know About Dates in Excel\",\"datePublished\":\"2020-04-10T15:28:34+00:00\",\"dateModified\":\"2020-04-12T09:58:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/\"},\"wordCount\":594,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/spreadsheetcenter.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/\",\"url\":\"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/\",\"name\":\"What You Should Know About Dates in Excel - Spreadsheet Center\",\"isPartOf\":{\"@id\":\"https:\/\/spreadsheetcenter.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280.jpg\",\"datePublished\":\"2020-04-10T15:28:34+00:00\",\"dateModified\":\"2020-04-12T09:58:19+00:00\",\"description\":\"Excel can do some funky things to your date and time values. We're looking at how Excel handles dates behind the scenes and how to solve common date issues.\",\"breadcrumb\":{\"@id\":\"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#primaryimage\",\"url\":\"https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280.jpg\",\"contentUrl\":\"https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280.jpg\",\"width\":1280,\"height\":853,\"caption\":\"Another type of date ;)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/spreadsheetcenter.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What You Should Know About Dates in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/spreadsheetcenter.com\/#website\",\"url\":\"https:\/\/spreadsheetcenter.com\/\",\"name\":\"Spreadsheet Center\",\"description\":\"Learn Excel quickly by doing\",\"publisher\":{\"@id\":\"https:\/\/spreadsheetcenter.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/spreadsheetcenter.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/spreadsheetcenter.com\/#organization\",\"name\":\"Learn Excel\",\"url\":\"https:\/\/spreadsheetcenter.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/spreadsheetcenter.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2019\/08\/LearnExcelLogo.png\",\"contentUrl\":\"https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2019\/08\/LearnExcelLogo.png\",\"width\":915,\"height\":396,\"caption\":\"Learn Excel\"},\"image\":{\"@id\":\"https:\/\/spreadsheetcenter.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/spreadsheetcenter.com\/#\/schema\/person\/5b09281482bdf1753c0885ca6e18fff1\",\"name\":\"Spreadsheet Center\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/spreadsheetcenter.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fff54a9b87536e5d4fac979767d07984?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fff54a9b87536e5d4fac979767d07984?s=96&d=mm&r=g\",\"caption\":\"Spreadsheet Center\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What You Should Know About Dates in Excel - Spreadsheet Center","description":"Excel can do some funky things to your date and time values. We're looking at how Excel handles dates behind the scenes and how to solve common date issues.","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:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"What You Should Know About Dates in Excel - Spreadsheet Center","og_description":"Excel can do some funky things to your date and time values. We're looking at how Excel handles dates behind the scenes and how to solve common date issues.","og_url":"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/","og_site_name":"Spreadsheet Center","article_published_time":"2020-04-10T15:28:34+00:00","article_modified_time":"2020-04-12T09:58:19+00:00","og_image":[{"width":1280,"height":853,"url":"https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280.jpg","type":"image\/jpeg"}],"author":"Spreadsheet Center","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Spreadsheet Center","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#article","isPartOf":{"@id":"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/"},"author":{"name":"Spreadsheet Center","@id":"https:\/\/spreadsheetcenter.com\/#\/schema\/person\/5b09281482bdf1753c0885ca6e18fff1"},"headline":"What You Should Know About Dates in Excel","datePublished":"2020-04-10T15:28:34+00:00","dateModified":"2020-04-12T09:58:19+00:00","mainEntityOfPage":{"@id":"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/"},"wordCount":594,"commentCount":1,"publisher":{"@id":"https:\/\/spreadsheetcenter.com\/#organization"},"image":{"@id":"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/","url":"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/","name":"What You Should Know About Dates in Excel - Spreadsheet Center","isPartOf":{"@id":"https:\/\/spreadsheetcenter.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280.jpg","datePublished":"2020-04-10T15:28:34+00:00","dateModified":"2020-04-12T09:58:19+00:00","description":"Excel can do some funky things to your date and time values. We're looking at how Excel handles dates behind the scenes and how to solve common date issues.","breadcrumb":{"@id":"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#primaryimage","url":"https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280.jpg","contentUrl":"https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280.jpg","width":1280,"height":853,"caption":"Another type of date ;)"},{"@type":"BreadcrumbList","@id":"https:\/\/spreadsheetcenter.com\/what-you-should-know-about-dates-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/spreadsheetcenter.com\/"},{"@type":"ListItem","position":2,"name":"What You Should Know About Dates in Excel"}]},{"@type":"WebSite","@id":"https:\/\/spreadsheetcenter.com\/#website","url":"https:\/\/spreadsheetcenter.com\/","name":"Spreadsheet Center","description":"Learn Excel quickly by doing","publisher":{"@id":"https:\/\/spreadsheetcenter.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/spreadsheetcenter.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/spreadsheetcenter.com\/#organization","name":"Learn Excel","url":"https:\/\/spreadsheetcenter.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/spreadsheetcenter.com\/#\/schema\/logo\/image\/","url":"https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2019\/08\/LearnExcelLogo.png","contentUrl":"https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2019\/08\/LearnExcelLogo.png","width":915,"height":396,"caption":"Learn Excel"},"image":{"@id":"https:\/\/spreadsheetcenter.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/spreadsheetcenter.com\/#\/schema\/person\/5b09281482bdf1753c0885ca6e18fff1","name":"Spreadsheet Center","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/spreadsheetcenter.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fff54a9b87536e5d4fac979767d07984?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fff54a9b87536e5d4fac979767d07984?s=96&d=mm&r=g","caption":"Spreadsheet Center"}}]}},"uagb_featured_image_src":{"full":["https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280.jpg",1280,853,false],"thumbnail":["https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280-150x150.jpg",150,150,true],"medium":["https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280-300x200.jpg",300,200,true],"medium_large":["https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280-768x512.jpg",768,512,true],"large":["https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280-1024x682.jpg",1024,682,true],"hd_qu_size2":["https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280-400x400.jpg",400,400,true],"1536x1536":["https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280.jpg",1280,853,false],"2048x2048":["https:\/\/spreadsheetcenter.com\/wp-content\/uploads\/2020\/04\/people-2557408_1280.jpg",1280,853,false]},"uagb_author_info":{"display_name":"Spreadsheet Center","author_link":"https:\/\/spreadsheetcenter.com\/author\/learnexcel\/"},"uagb_comment_info":1,"uagb_excerpt":"What's up with dates and times in Excel? What is a serial number? And what does the date January 1st, 1900 have to do with it? Today, we're de-mystifying dates in Excel.","amp_enabled":true,"mfb_rest_fields":["yoast_head","yoast_head_json","uagb_featured_image_src","uagb_author_info","uagb_comment_info","uagb_excerpt","amp_enabled"],"_links":{"self":[{"href":"https:\/\/spreadsheetcenter.com\/wp-json\/wp\/v2\/posts\/2767"}],"collection":[{"href":"https:\/\/spreadsheetcenter.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spreadsheetcenter.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spreadsheetcenter.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/spreadsheetcenter.com\/wp-json\/wp\/v2\/comments?post=2767"}],"version-history":[{"count":6,"href":"https:\/\/spreadsheetcenter.com\/wp-json\/wp\/v2\/posts\/2767\/revisions"}],"predecessor-version":[{"id":2848,"href":"https:\/\/spreadsheetcenter.com\/wp-json\/wp\/v2\/posts\/2767\/revisions\/2848"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spreadsheetcenter.com\/wp-json\/wp\/v2\/media\/2771"}],"wp:attachment":[{"href":"https:\/\/spreadsheetcenter.com\/wp-json\/wp\/v2\/media?parent=2767"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spreadsheetcenter.com\/wp-json\/wp\/v2\/categories?post=2767"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spreadsheetcenter.com\/wp-json\/wp\/v2\/tags?post=2767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}