{"id":43426,"date":"2024-04-25T01:53:26","date_gmt":"2024-04-24T23:53:26","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=43426"},"modified":"2024-04-22T18:48:58","modified_gmt":"2024-04-22T16:48:58","slug":"datepart-function","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/datepart-function\/","title":{"rendered":"How to Simplify Dates with DATEPART Function in Excel VBA"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Datepart-function.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-43669 size-large\" title=\"Datepart function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Datepart-function-1024x576.png\" alt=\"Datepart function\" width=\"640\" height=\"360\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Datepart-function-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Datepart-function-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Datepart-function-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Datepart-function-180x100.png 180w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Datepart-function.png 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/\" target=\"_blank\" rel=\"noopener\">Excel VBA<\/a>, coupled with the DATEPART function, simplifies date management in Microsoft Excel. <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/011-excel-vba-pro-course-jon-acampora-from-excelcampus\/\" target=\"_blank\" rel=\"noopener\">With VBA&#8217;s<\/a> automation capabilities, you can tackle intricate date manipulations, streamlining your data handling process. In this article, we will learn how to use DATEPART in Excel VBA to extract specific date components.<\/p>\n<p><strong>Key Takeaways:<\/strong><\/p>\n<ul>\n<li>Automate Complexity: VBA empowers you to automate intricate date manipulations, enhancing efficiency in Excel.<\/li>\n<li>Precision Extraction: DATEPART extracts specific date components like year, month, or even seconds, enabling tailored data analysis.<\/li>\n<li>Flexible Functionality: DATEPART offers adaptability by returning various values based on specified intervals, catering to diverse analytical needs.<\/li>\n<li>Step-by-Step Guidance: Detailed examples guide you through implementing DATEPART, ensuring seamless integration into your Excel workflows.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/datepart-function\/#Introduction_to_Excel_VBA_and_the_DATEPART_Function\" title=\"Introduction to Excel VBA and the DATEPART Function\">Introduction to Excel VBA and the DATEPART Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/datepart-function\/#Breaking_Down_the_DATEPART_Function\" title=\"Breaking Down the DATEPART Function\">Breaking Down the DATEPART Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/datepart-function\/#Step-by-Step_Examples_Using_DATEPART\" title=\"Step-by-Step Examples Using DATEPART\">Step-by-Step Examples Using DATEPART<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/datepart-function\/#Troubleshooting_Common_Issues_with_DATEPART\" title=\"Troubleshooting Common Issues with DATEPART\">Troubleshooting Common Issues with DATEPART<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/datepart-function\/#Frequently_Asked_Questions_FAQ\" title=\"Frequently Asked Questions (FAQ)\">Frequently Asked Questions (FAQ)<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Introduction_to_Excel_VBA_and_the_DATEPART_Function\"><\/span>Introduction to Excel VBA and the DATEPART Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Unlocking the Power of Dates in Excel with VBA<\/h3>\n<p>When you&#8217;re working with Excel, managing dates can get tricky, but <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-macros-vba-webinar-training\/\" target=\"_blank\" rel=\"noopener\">VBA (Visual Basic for Applications)<\/a> is a powerful ally in decoding this complexity. It allows you to automate almost any action you can perform in Excel, including comprehensive date manipulation that can revolutionize the way you handle your data.<\/p>\n<h3>Understanding the DATEPART Function&#8217;s Role in Date Manipulation<\/h3>\n<p>The DATEPART function is your secret weapon for laser-focused <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-date-and-time-functions\/\" target=\"_blank\" rel=\"noopener\">date manipulation<\/a>. It allows you to extract precise components from dates\u2014think a year, month, day, and even down to the second. This enables you to scrutinize and handle date values with unparalleled precision, tailoring data analysis and reporting to your specific needs.<\/p>\n<p>Consider using contextual visuals like screenshots or flowcharts illustrating how DATEPART can be integrated into date manipulation workflows to make this section even more engaging for the reader.<\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Breaking_Down_the_DATEPART_Function\"><\/span>Breaking Down the DATEPART Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Understanding DATEPART<\/h3>\n<p>DATEPART is a function commonly used in SQL, but it can also be employed in Excel VBA to extract parts of a date or time. Its syntax is straightforward:<\/p>\n<p><strong>DATEPART(interval, date)<\/strong><\/p>\n<p>The &#8216;interval&#8217; parameter specifies the date or time part to be returned, while &#8216;date&#8217; represents the input date or time value.<\/p>\n<p>Commonly Used Intervals:<\/p>\n<ul>\n<li>&#8220;yyyy&#8221; or &#8220;yy&#8221;: Returns the year portion of the date.<\/li>\n<li>&#8220;m&#8221; or &#8220;mm&#8221;: Retrieves the month part of the date.<\/li>\n<li>&#8220;d&#8221; or &#8220;dd&#8221;: Extracts the day from the date.<\/li>\n<li>&#8220;h&#8221; or &#8220;hh&#8221;: Gets the hour from the time.<\/li>\n<li>&#8220;n&#8221; or &#8220;nn&#8221;: Fetches the minute from the time.<\/li>\n<li>&#8220;s&#8221; or &#8220;ss&#8221;: Obtains the second from the time.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3>The Flexibility of DATEPART&#8217;s Return Values<\/h3>\n<p>DATEPART&#8217;s real prowess lies in its adaptability to return a range of values based on the &#8216;interval&#8217; you specify. Whether you&#8217;re looking for the year, quarter, month, day, weekday, or even time components like hour, minute, and second, DATEPART has got you covered.<\/p>\n<p>The ability to pinpoint these individual elements within a date or timestamp means you can customize how data is parsed and utilized, ranging from simple tasks like sorting events annually to complex calculations of time intervals between actions.<\/p>\n<p>For a more vivid depiction, a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/charts\/\" target=\"_blank\" rel=\"noopener\">chart<\/a> or a list illustrating various &#8216;interval&#8217; examples and their corresponding return values could be an excellent addition here, providing readers with a quick reference to understand the granularity DATEPART offers.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step-by-Step_Examples_Using_DATEPART\"><\/span>Step-by-Step Examples Using DATEPART<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Example 1 &#8211; Extracting Specific Date Components<\/h3>\n<p>Imagine needing to analyze sales data by year or manage a timeline for project deadlines\u2014extracting specific date components becomes indispensable. Here&#8217;s <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-many-days-in-4-years\/\" target=\"_blank\" rel=\"noopener\">how to use DATEPART in<\/a> Excel VBA to tease out the year from a given date:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong><\/span> Open the Visual Basic for Applications (VBA) Editor: Press ALT + F11 to open the VBA editor. Alternatively, you can go to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-macro-activate-the-developer-tab\/\" target=\"_blank\" rel=\"noopener\">the &#8220;Developer&#8221; tab<\/a> and click on &#8220;Visual Basic.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"DATEPART in excel vba\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641513962024-04-20T083A413A40.578439_DATEPART_in_Excel_VBA_1.png\" alt=\"DATEPART in excel vba\" width=\"1152\" height=\"239\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Insert a New Module: In the VBA editor, click on &#8220;Insert&#8221; in the menu bar and then select &#8220;Module&#8221;. This will insert a new module where you can write your VBA code.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"DATEPART in excel vba\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641513962024-04-20T083A413A53.683321_DATEPART_in_Excel_VBA_3.png\" alt=\"DATEPART in excel vba\" width=\"1122\" height=\"601\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong> <\/span>Copy and Paste the VBA Code: Copy the VBA code provided in the article:<\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">Sub YearFromDate()\r\n\r\nDim result As Integer\r\n\r\nDim myDate As Date\r\n\r\nmyDate = #7\/11\/2024#\r\n\r\nresult = DatePart(&amp;quot;yyyy&amp;quot;, myDate)\r\n\r\nMsgBox result\r\n\r\nEnd Sub<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"DATEPART in excel vba\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641513962024-04-20T083A423A10.323149_DATEPART_in_Excel_VBA_4.png\" alt=\"DATEPART in excel vba\" width=\"1469\" height=\"522\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4: <\/strong><\/span>Close the VBA Editor: Once you&#8217;ve pasted the code, close the VBA editor window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"DATEPART in excel vba\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641513962024-04-20T083A423A35.280037_DATEPART_in_Excel_VBA_5.png\" alt=\"DATEPART in excel vba\" width=\"1896\" height=\"667\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5:<\/strong><\/span> Run the Macro: To execute the macro, you have two options:<\/p>\n<ul>\n<li>Press ALT + F8 to open the &#8220;Macro&#8221; dialog box. Select the macro you want to run from the list (e.g., &#8220;YearFromDate&#8221;) and click &#8220;Run&#8221;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"DATEPART in excel vba\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641513962024-04-20T083A433A54.788992_DATEPART_in_Excel_VBA_7.png\" alt=\"DATEPART in excel vba\" width=\"1259\" height=\"750\" \/><\/p>\n<ul>\n<li>Alternatively, you can assign the macro to a button or shape in your worksheet. Right-click on the button or shape, select &#8220;Assign Macro&#8221;, choose the macro you want to run, and click &#8220;OK&#8221;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"DATEPART in excel vba\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641513962024-04-20T083A443A13.617315_DATEPART_in_Excel_VBA_.png\" alt=\"DATEPART in excel vba\" width=\"1193\" height=\"759\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 6:<\/strong> <\/span>View the Results: Depending on the macro you ran, you&#8217;ll either see message boxes displaying the extracted date components or the macro will perform actions based on the categorized dates.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"DATEPART in excel vba\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641513962024-04-20T083A443A25.903341_DATEPART_in_Excel_VBA_8.png\" alt=\"DATEPART in excel vba\" width=\"596\" height=\"441\" \/><\/p>\n<p>After running this subroutine, a message box pops up, showcasing &#8220;2024&#8221; \u2013 the year extracted from the date. It&#8217;s proof of how effortlessly you can distill essential data points from dates for reporting, analysis, or any other application where the temporal element is vital.<\/p>\n<p>&nbsp;<\/p>\n<h3>Example 2 &#8211; Dealing with Time Values: Hours, Minutes, and Seconds<\/h3>\n<p>Let&#8217;s delve into time values within dates. If you&#8217;re looking to break down a timestamp into hours, minutes, or seconds, DATEPART sails to the rescue once again. Here&#8217;s an example that siphons off the minute from a specific time:<\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">Sub MinuteFromTime()\r\n\r\nDim result As Integer\r\n\r\nDim myTime As Date\r\n\r\nmyTime = #10:15:30 AM#\r\n\r\nresult = DatePart(&amp;quot;n&amp;quot;, myTime)\r\n\r\nMsgBox &amp;quot;The minute component is: &amp;quot; &amp;amp; result\r\n\r\nEnd Sub<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"DATEPART in excel vba\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641513962024-04-20T083A443A54.236175_DATEPART_in_Excel_VBA_13.png\" alt=\"DATEPART in excel vba\" width=\"1075\" height=\"572\" \/><\/p>\n<p>Running this subroutine, a message box will inform you that the minute component is &#8220;15&#8221;\u2014the minutes from our given time.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"DATEPART in excel vba\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641513962024-04-20T083A453A08.848949_DATEPART_in_Excel_VBA_12.png\" alt=\"DATEPART in excel vba\" width=\"675\" height=\"396\" \/><\/p>\n<p>This technique is invaluable for precise time tracking or event logging, ensuring that your data&#8217;s temporal precision is down to the last second.<\/p>\n<p>Visual aids such as screenshots or even a short video could greatly enhance the reader&#8217;s comprehension here, bringing to life the journey from the VBA coding environment to the tangible outputs and benefits.<\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Troubleshooting_Common_Issues_with_DATEPART\"><\/span>Troubleshooting Common Issues with DATEPART<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Understanding Error Messages and Their Solutions<\/h3>\n<p>Navigating the common error messages that DATEPART may throw at you is crucial to smooth VBA programming. If you encounter a &#8216;Type Mismatch&#8217; error, it often means that the date you&#8217;ve provided isn&#8217;t recognized as a valid date or the interval isn&#8217;t specified correctly. Double-checking your input and ensuring it matches <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-and-subtract-dates\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;s date<\/a> format should resolve this.<\/p>\n<p>Another typical mistake that causes errors is using the wrong interval string, like mistyping &#8220;mm&#8221; for month instead of &#8220;m&#8221;. This minor slip can be avoided by familiarizing yourself with the correct interval codes.<\/p>\n<p>To help clarify solutions, you could include a table summarizing common error messages, causes, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/shortcuts\/tips-and-tricks\/\" target=\"_blank\" rel=\"noopener\">and troubleshooting tips<\/a>, providing a handy reference for programmers to diagnose and fix issues quickly.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions_FAQ\"><\/span>Frequently Asked Questions (FAQ)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>What is Excel VBA?<\/h3>\n<p>VBA, or Visual Basic for Applications, is a programming language built into <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/microsoft-excel-online-course-private-access-20-hours-beginner-to-advanced-course\/\" target=\"_blank\" rel=\"noopener\">Microsoft Excel<\/a>. It&#8217;s a tool that enables you to automate repetitive tasks and create custom functions and complex calculations beyond what standard Excel features provide. They can use it to enhance their productivity by automating virtually any action that they can manually perform in Excel.<\/p>\n<h3>What is the difference between datepart and date functions in Excel vba?<\/h3>\n<p>In Excel VBA, the <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/datepart-function-26868a79-5505-4e5a-8905-6001372223fa#:~:text=You%20can%20use%20the%20DatePart,and%20%22ww%22%20interval%20symbols.\" target=\"_blank\" rel=\"nofollow noopener\">DATEPART function<\/a> extracts a specific part of a date, such as year, month, or day, whereas DATE functions like DATE() create a date based on individual year, month, and day components. They use DATEPART primarily for breaking down existing dates, while DATE functions are used to construct new dates or convert date information into serial <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/predetermined-number-formatting\/\" target=\"_blank\" rel=\"noopener\">number format<\/a>.<\/p>\n<h3>What is Excel vba datepart function?<\/h3>\n<p>The Excel VBA DATEPART function is a versatile tool within the VBA programming environment used to extract a specific part\u2014such as the year, month, day, or time component\u2014from a date or time value. It simplifies handling and analyzing date-related data, making it easier to work with temporal elements in Excel spreadsheets programmatically.<\/p>\n<h3>How to use the datepart function in Excel vba?<\/h3>\n<p>To use the DATEPART function in Excel VBA, write a subroutine or a function within the VBA editor, specify the interval of the date you want to extract, and provide a valid date value. Here\u2019s a simple usage example:<\/p>\n<div class=\"ql-code-block-container\">\n<div class=\"ql-code-block\" data-language=\"plain\">Sub UseDatePart()<\/div>\n<div class=\"ql-code-block\" data-language=\"plain\">Dim extractValue As Integer<\/div>\n<div class=\"ql-code-block\" data-language=\"plain\">Dim givenDate As Date<\/div>\n<div class=\"ql-code-block\" data-language=\"plain\">givenDate = #3\/14\/2023#<\/div>\n<div class=\"ql-code-block\" data-language=\"plain\">extractValue = DatePart(&#8220;m&#8221;, givenDate)<\/div>\n<div class=\"ql-code-block\" data-language=\"plain\">MsgBox &#8220;The month is: &#8221; &amp; extractValue<\/div>\n<div class=\"ql-code-block\" data-language=\"plain\">End Sub<\/div>\n<\/div>\n<p>In this snippet, the function extracts the month from the <code>givenDate<\/code>. Run the subroutine to see the result, in this case, &#8220;3&#8221; for March, in a message box.<\/p>\n<h3>Why is vba datepart not working in Excel?<\/h3>\n<p>If the VBA DATEPART function isn&#8217;t working in Excel, check the valid format of your date or time expression, the interval argument&#8217;s spelling and casing, and that all necessary arguments are provided in the correct order. Also, look for any variable naming or scope issues in the code. Lastly, make sure the referenced date fits within the Gregorian calendar&#8217;s supported range.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn Excel VBA date-handling skills with the DATEPART function. Simplify complex date calculations and enhance data analysis with our expert tips.<\/p>\n","protected":false},"author":1,"featured_media":43669,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[56],"tags":[2464,2465,2466],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/43426"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=43426"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/43426\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/43669"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=43426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=43426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=43426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}