{"id":52,"date":"2013-01-05T14:48:04","date_gmt":"2013-01-05T03:48:04","guid":{"rendered":"http:\/\/www.rtb.com.au\/blog\/?p=52"},"modified":"2016-04-18T13:01:33","modified_gmt":"2016-04-18T03:01:33","slug":"working-with-dates-in-excel","status":"publish","type":"post","link":"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/","title":{"rendered":"Working with Dates in Excel"},"content":{"rendered":"
\"Working
Working with dates in Excel<\/figcaption><\/figure>\n

I’ve been\u00a0a Microsoft Office Master Instructor for over 12 years now and\u00a0I’ve\u00a0seen some pretty silly things in Excel when it comes to working with dates. Most people don\u2019t understand how dates are stored so they tend to do whatever it takes to get an answer to their problem. This result often leads to more work,\u00a0heartache and pain further down the track or\u00a0they simply\u00a0just don’t get\u00a0the right answer. In their eyes, ‘close enough is good enough’. Some of the Insidious, diabolical, mega\u00a0formulas I’ve seen would leave mathematicians scratching their heads.\u00a0Lets take a closer look at working with dates in Excel. <\/p>\n

Firstly, do you know how dates are stored? If you don\u2019t, follow these steps.<\/p>\n

In a blank cell in Excel<\/p>\n

    \n
  1. Type in today\u2019s date or\u00a0Ctrl + ; (semicolon)\u00a0for the keyboard shortcut fans.\n
    \"Insert<\/a>
    Today’s date<\/figcaption><\/figure>\n

    If you are typing out the date, only ever use a forward slash (\/)\u00a0or a dash (-)\u00a0to separate the days, months and years. Definitely no full stops (.) e.g\u00a0 5.1.2013 is just plain wrong. Excel looks at this number with 2 lots of decimal places, gives up and recognises it as text. This is easy to identify because the\u00a0data will be left aligned in the cell.\u00a0For this very reason it now means that you cannot reformat the cell to a different date format (in-built or custom date format) and you cannot use this date in a calculation as you would be able to with a valid date.\u00a0<\/span><\/li>\n

  2. Format that same cell to a number using format cells.\u00a0Ctrl +\u00a0 1\u00a0will get into format cells for the keyboard shortcut fans.\n

    \"Format<\/a>
    This is the Format Cells Dialogue Box – Ctrl + 1<\/figcaption><\/figure><\/li>\n
  3. On the number tab, change the format from a date back to a number with 2 decimal places.\n

    \"Format<\/a>
    Format the cell to a number format using Format Cells Dialogue Box – Ctrl + 1<\/figcaption><\/figure><\/li>\n
  4. Click OK You should have a number over 40,000 in this cell.\n
    \"Today's<\/a>
    Today’s Date represented as a number<\/figcaption><\/figure>\n

    This represents the number of days since the 1st of January 1900.\u00a0That’s it, dates\u00a0are really just stored as numbers. As long as you remember this you can work with dates quite easily in Excel.\u00a0If you want to confirm this, type the number 1 into another blank cell and format it back to a date \u2013 use the long date format. It will show you (Sunday, 1 January 1900). That\u2019s day 1 as far as Excel is concerned.<\/li>\n<\/ol>\n

    To take this concept a little further let’s make another little change. Click back on the cell that was originally today’s date. This cell still should be displaying a number. Change the 2 zeros after the decimal place to .25 (for example 41278.25). If you are wondering what this represents, read on. If a date is stored as the number of days since the 1st of January 1900 then a .25 would represent a quarter of a day. That’s 24 hours divided by 4\u00a0or 6 hours…. which is really 6am. Quite simply put, whole numbers represent the date and the decimal places represent time. If you want to confirm this do the following.<\/p>\n

      \n
    1. Ensure the cell with the number is still selected.<\/li>\n
    2. Go to format cells (Ctrl + 1)<\/li>\n
    3. Select the Number tab<\/li>\n
    4. Select Custom at the bottom of the list<\/li>\n
    5. Under Type: remove the 0.00<\/li>\n
    6. Type or copy and paste\u00a0the following custom date and time format: d\/mm\/yyyy h:mm am\/pm<\/li>\n
    7. Click OK<\/li>\n<\/ol>\n

      Voila! You can now see how Excel stores dates and time. Treat your dates and times as normal numbers. For instance, if you wanted to work out how old someone is , use the following formula. Let’s assume their birthday is in cell A1.<\/p>\n

      The formula would look something like this:
      \n=INT((TODAY()-A1)\/365.25)<\/p>\n

      Let’s break it down. TODAY()-A1 will calculate the number of days old the person is.\u00a0For some of us, that\u2019s really a bit scary.\u00a0We then divide this by 365.25 to work out how many years old they are. The .25 is used to cater for the leap year ever 4 years. Then finally,\u00a0INT is the integer function which changes any numeric result to an integer or whole number. It basically ignores all decimal places. Think of it as chopping them off. This leaves us with their age.<\/p>\n

      For more information from Microsoft\u00a0on working with custom date formats click here<\/a>\u00a0or<\/p>\n

      Attend an Excel Intermediate Training Course in Sydney\u00a0at Raising the Bar<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

      I’ve been\u00a0a Microsoft Office Master Instructor for over 12 years now and\u00a0I’ve\u00a0seen some pretty silly things in Excel when it comes to working with dates. Most people don\u2019t understand how dates are stored so they tend to do whatever it takes to get an answer to their problem. This result often leads to more work,\u00a0heartache … Continue reading “Working with Dates in Excel”<\/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":[12],"tags":[],"class_list":["post-52","post","type-post","status-publish","format-standard","hentry","category-excel-tips"],"yoast_head":"\r\nWorking with Dates in Excel - Raising the Bar Blog<\/title>\r\n<meta name=\"description\" content=\"Working with dates in Microsoft Excel is easy once you know how. Many people over think the process because they don't know how dates are stored in Excel\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Working with Dates in Excel - Raising the Bar Blog\" \/>\r\n<meta property=\"og:description\" content=\"Working with dates in Microsoft Excel is easy once you know how. Many people over think the process because they don't know how dates are stored in Excel\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/\" \/>\r\n<meta property=\"og:site_name\" content=\"Raising the Bar Blog\" \/>\r\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/raisingthebartraining\/\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/raisingthebartraining\" \/>\r\n<meta property=\"article:published_time\" content=\"2013-01-05T03:48:04+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2016-04-18T03:01:33+00:00\" \/>\r\n<meta property=\"og:image\" content=\"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/calendar.jpg\" \/>\r\n<meta name=\"author\" content=\"Craig Holmes\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Craig Holmes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/\"},\"author\":{\"name\":\"Craig Holmes\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#\/schema\/person\/a6a72f7f4febfa4e11ec9680390b598b\"},\"headline\":\"Working with Dates in Excel\",\"datePublished\":\"2013-01-05T03:48:04+00:00\",\"dateModified\":\"2016-04-18T03:01:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/\"},\"wordCount\":774,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/calendar.jpg\",\"articleSection\":[\"Excel Tips\"],\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/\",\"url\":\"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/\",\"name\":\"Working with Dates in Excel - Raising the Bar Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/calendar.jpg\",\"datePublished\":\"2013-01-05T03:48:04+00:00\",\"dateModified\":\"2016-04-18T03:01:33+00:00\",\"description\":\"Working with dates in Microsoft Excel is easy once you know how. Many people over think the process because they don't know how dates are stored in Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#primaryimage\",\"url\":\"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/calendar.jpg\",\"contentUrl\":\"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/calendar.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rtb.com.au\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Working with Dates in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#website\",\"url\":\"https:\/\/www.rtb.com.au\/blog\/\",\"name\":\"Raising the Bar Blog\",\"description\":\"Computer Training Courses\",\"publisher\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.rtb.com.au\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-AU\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#organization\",\"name\":\"Raising the Bar\",\"url\":\"https:\/\/www.rtb.com.au\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2019\/01\/new-rtb-logo-dark.png\",\"contentUrl\":\"https:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2019\/01\/new-rtb-logo-dark.png\",\"width\":220,\"height\":113,\"caption\":\"Raising the Bar\"},\"image\":{\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/raisingthebartraining\/\",\"https:\/\/x.com\/rtb_training\",\"https:\/\/www.instagram.com\/raisingthebartraining\/\",\"https:\/\/www.linkedin.com\/company\/1814856\/\",\"https:\/\/www.youtube.com\/channel\/UC0Qj5rg6wRga_2EN6hFEnCA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#\/schema\/person\/a6a72f7f4febfa4e11ec9680390b598b\",\"name\":\"Craig Holmes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/www.rtb.com.au\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f7040c244704cf995b7aca5eb017a980012d0221b6f214d86953bd12fab9b8ca?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f7040c244704cf995b7aca5eb017a980012d0221b6f214d86953bd12fab9b8ca?s=96&d=mm&r=g\",\"caption\":\"Craig Holmes\"},\"description\":\"Microsoft Office Master Instructor and owner of Raising the Bar. Formerly trained as an Aircraft Technician with the RAAF\",\"sameAs\":[\"http:\/\/www.rtb.com.au\",\"https:\/\/www.facebook.com\/raisingthebartraining\"],\"url\":\"https:\/\/www.rtb.com.au\/blog\/author\/caholmes\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Working with Dates in Excel - Raising the Bar Blog","description":"Working with dates in Microsoft Excel is easy once you know how. Many people over think the process because they don't know how dates are stored in Excel","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:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Working with Dates in Excel - Raising the Bar Blog","og_description":"Working with dates in Microsoft Excel is easy once you know how. Many people over think the process because they don't know how dates are stored in Excel","og_url":"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/","og_site_name":"Raising the Bar Blog","article_publisher":"https:\/\/www.facebook.com\/raisingthebartraining\/","article_author":"https:\/\/www.facebook.com\/raisingthebartraining","article_published_time":"2013-01-05T03:48:04+00:00","article_modified_time":"2016-04-18T03:01:33+00:00","og_image":[{"url":"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/calendar.jpg","type":"","width":"","height":""}],"author":"Craig Holmes","twitter_misc":{"Written by":"Craig Holmes","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/"},"author":{"name":"Craig Holmes","@id":"https:\/\/www.rtb.com.au\/blog\/#\/schema\/person\/a6a72f7f4febfa4e11ec9680390b598b"},"headline":"Working with Dates in Excel","datePublished":"2013-01-05T03:48:04+00:00","dateModified":"2016-04-18T03:01:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/"},"wordCount":774,"commentCount":0,"publisher":{"@id":"https:\/\/www.rtb.com.au\/blog\/#organization"},"image":{"@id":"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#primaryimage"},"thumbnailUrl":"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/calendar.jpg","articleSection":["Excel Tips"],"inLanguage":"en-AU","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/","url":"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/","name":"Working with Dates in Excel - Raising the Bar Blog","isPartOf":{"@id":"https:\/\/www.rtb.com.au\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#primaryimage"},"thumbnailUrl":"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/calendar.jpg","datePublished":"2013-01-05T03:48:04+00:00","dateModified":"2016-04-18T03:01:33+00:00","description":"Working with dates in Microsoft Excel is easy once you know how. Many people over think the process because they don't know how dates are stored in Excel","breadcrumb":{"@id":"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#breadcrumb"},"inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#primaryimage","url":"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/calendar.jpg","contentUrl":"http:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2013\/01\/calendar.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rtb.com.au\/blog\/working-with-dates-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rtb.com.au\/blog\/"},{"@type":"ListItem","position":2,"name":"Working with Dates in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.rtb.com.au\/blog\/#website","url":"https:\/\/www.rtb.com.au\/blog\/","name":"Raising the Bar Blog","description":"Computer Training Courses","publisher":{"@id":"https:\/\/www.rtb.com.au\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rtb.com.au\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-AU"},{"@type":"Organization","@id":"https:\/\/www.rtb.com.au\/blog\/#organization","name":"Raising the Bar","url":"https:\/\/www.rtb.com.au\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.rtb.com.au\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2019\/01\/new-rtb-logo-dark.png","contentUrl":"https:\/\/www.rtb.com.au\/blog\/wp-content\/uploads\/2019\/01\/new-rtb-logo-dark.png","width":220,"height":113,"caption":"Raising the Bar"},"image":{"@id":"https:\/\/www.rtb.com.au\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/raisingthebartraining\/","https:\/\/x.com\/rtb_training","https:\/\/www.instagram.com\/raisingthebartraining\/","https:\/\/www.linkedin.com\/company\/1814856\/","https:\/\/www.youtube.com\/channel\/UC0Qj5rg6wRga_2EN6hFEnCA"]},{"@type":"Person","@id":"https:\/\/www.rtb.com.au\/blog\/#\/schema\/person\/a6a72f7f4febfa4e11ec9680390b598b","name":"Craig Holmes","image":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.rtb.com.au\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f7040c244704cf995b7aca5eb017a980012d0221b6f214d86953bd12fab9b8ca?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f7040c244704cf995b7aca5eb017a980012d0221b6f214d86953bd12fab9b8ca?s=96&d=mm&r=g","caption":"Craig Holmes"},"description":"Microsoft Office Master Instructor and owner of Raising the Bar. Formerly trained as an Aircraft Technician with the RAAF","sameAs":["http:\/\/www.rtb.com.au","https:\/\/www.facebook.com\/raisingthebartraining"],"url":"https:\/\/www.rtb.com.au\/blog\/author\/caholmes\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/posts\/52","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/comments?post=52"}],"version-history":[{"count":45,"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/posts\/52\/revisions"}],"predecessor-version":[{"id":668,"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/posts\/52\/revisions\/668"}],"wp:attachment":[{"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/media?parent=52"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/categories?post=52"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rtb.com.au\/blog\/wp-json\/wp\/v2\/tags?post=52"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}