{"id":42251,"date":"2024-04-11T17:49:44","date_gmt":"2024-04-11T15:49:44","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=42251"},"modified":"2024-04-10T08:58:01","modified_gmt":"2024-04-10T06:58:01","slug":"datedif-to-calculate-date-difference","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/datedif-to-calculate-date-difference\/","title":{"rendered":"The Ultimate Guide to Calculate Date Differences in Excel"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Calculate-date-difference-.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-42546 size-large\" title=\"Calculate date difference\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Calculate-date-difference--1024x576.png\" alt=\"Calculate date difference\" width=\"640\" height=\"360\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Calculate-date-difference--1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Calculate-date-difference--300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Calculate-date-difference--768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Calculate-date-difference--180x100.png 180w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Calculate-date-difference-.png 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><br \/>\nDiscover the potential of <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\">Microsoft Excel<\/a>&#8216;s DATEDIF function, a vital tool to calculate date difference. From tracking project deadlines to calculating exact ages, DATEDIF simplifies complex time-related data analysis, making it an essential skill for efficient Excel usage.<\/p>\n<h3>Key Takeaways<\/h3>\n<ul>\n<li>Basic Syntax Mastery: Understand the DATEDIF function&#8217;s basic syntax, =DATEDIF(start_date, end_date, &#8220;unit&#8221;), to perform accurate date difference calculations.<\/li>\n<li>Versatile Unit Options: Familiarize yourself with DATEDIF&#8217;s diverse units (&#8220;y&#8221;, &#8220;m&#8221;, &#8220;d&#8221;, &#8220;md&#8221;, &#8220;ym&#8221;, &#8220;yd&#8221;) for tailored calculations, enhancing your data analysis flexibility.<\/li>\n<li>Practical Applications: Utilize DATEDIF for real-world applications such as calculating ages from birthdates or determining the tenure between significant dates, adding value to your data management tasks.<\/li>\n<li>Advanced Usage: Combine DATEDIF with other functions (e.g., TODAY(), IF) for complex, nuanced date calculations, addressing specific analytical needs with customized solutions.<\/li>\n<li>Error Troubleshooting: Learn to troubleshoot common DATEDIF errors, such as incorrect unit parameters or date format issues, ensuring smooth and error-free calculations.<\/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\/datedif-to-calculate-date-difference\/#Introduction\" title=\"Introduction\">Introduction<\/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\/datedif-to-calculate-date-difference\/#Understanding_DATEDIF_Function\" title=\"Understanding DATEDIF Function\">Understanding DATEDIF 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\/datedif-to-calculate-date-difference\/#Practical_Applications_of_DATEDIF\" title=\"Practical Applications of DATEDIF\">Practical Applications of DATEDIF<\/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\/datedif-to-calculate-date-difference\/#Advanced_Tips_and_Tricks\" title=\"Advanced Tips and Tricks\">Advanced Tips and Tricks<\/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\/datedif-to-calculate-date-difference\/#Enhance_Your_Excel_Skills\" title=\"Enhance Your Excel Skills\">Enhance Your Excel Skills<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/datedif-to-calculate-date-difference\/#FAQ_Section\" title=\"FAQ Section\">FAQ Section<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Introduction\"><\/span>Introduction<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Unveiling the Power of DATEDIF in Excel<\/h3>\n<p>Dates are more than just numbers on a calendar\u2014they are crucial markers in time management, project planning, and historical tracking. Microsoft Excel, a powerhouse in data analysis, acknowledges this through its <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/datedif-function-introduction\/\" target=\"_blank\" rel=\"noopener\">DATEDIF function<\/a>. Whether you&#8217;re looking to determine someone&#8217;s exact age or count down to a project deadline, DATEDIF is your go-to tool.<\/p>\n<h3>Calculating Dates Efficiently with DATEDIF<\/h3>\n<p>When it comes to managing date calculations effectively, the DATEDIF function becomes indispensable. With its ability to churn out results in years, months, or days, you can bid farewell to manual calculations that are both time-consuming and error-prone. Harnessing DATEDIF allows you to automate these calculations, ensuring accuracy while saving precious time.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Understanding_DATEDIF_Function\"><\/span>Understanding DATEDIF Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>The Basic Syntax of DATEDIF<\/h3>\n<p>Understanding the basic syntax of DATEDIF is the cornerstone to leveraging its full potential. The formula appears as follows:<\/p>\n<div class=\"ql-code-block-container\">\n<div class=\"ql-code-block\" data-language=\"plain\">=DATEDIF(start_date, end_date, &#8220;unit&#8221;)<\/div>\n<\/div>\n<p>To grasp how it works, imagine you want to find the number of complete years, months, and days from January 1, 2022, to March 1, 2024. You&#8217;ll use:<\/p>\n<div class=\"ql-code-block-container\">\n<div class=\"ql-code-block\" data-language=\"plain\">=DATEDIF(&#8220;1-Jan-2022&#8221;, &#8220;1-Mar-2024&#8221;, &#8220;y&#8221;) \/\/ returns 2<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Datedif to calculate date difference\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia639879072024-04-07T073A373A03.435588_Datedif_to_calculate_date_difference_1.png\" alt=\"Datedif to calculate date difference\" width=\"755\" height=\"266\" \/><\/p>\n<p>This simple expression uses the DATEDIF function to return a precise period, ensuring you are well-equipped for any kind of date arithmetic in Excel.<\/p>\n<p>&nbsp;<\/p>\n<h3>Different Units of Measurement within DATEDIF<\/h3>\n<p>DATEDIF expands your analytical capabilities by offering you a palette of time units to measure intervals with precision. Here are the units at your disposal:<\/p>\n<ul>\n<li><code>\"y\"<\/code>: Returns the difference in full years.<\/li>\n<li><code>\"m\"<\/code>: Computes the total number of complete months.<\/li>\n<li><code>\"d\"<\/code>: Gives you the difference in days.<\/li>\n<li><code>\"md\"<\/code>: Calculates the days difference, ignoring months and years.<\/li>\n<li><code>\"ym\"<\/code>: Shows the difference in months, disregarding years.<\/li>\n<li><code>\"yd\"<\/code>: Reveals the difference in days, leaving out years.<\/li>\n<\/ul>\n<p>Understanding these units ensures you can tailor your date difference calculations to suit specific needs, whether that&#8217;s calculating the tenure of an employee or countdown to a product launch.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Practical_Applications_of_DATEDIF\"><\/span>Practical Applications of DATEDIF<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Calculating Age from a Birthdate<\/h3>\n<p>To convert a birthdate into an exact age, turn to the DATEDIF function with the TODAY() formula as your end date marker. For a birthdate entered in cell A2, here&#8217;s how it&#8217;s done:<\/p>\n<div class=\"ql-code-block-container\">\n<div class=\"ql-code-block\" data-language=\"plain\">=DATEDIF(A2, TODAY(), &#8220;y&#8221;)<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Datedif to calculate date difference\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia639879072024-04-07T073A413A24.170170_Datedif_to_calculate_date_difference_2.png\" alt=\"Datedif to calculate date difference\" width=\"620\" height=\"266\" \/><\/p>\n<p>But to grasp the complete age in years, months, and days, concatenate different DATEDIF units like this:<\/p>\n<div class=\"ql-code-block-container\">\n<div class=\"ql-code-block\" data-language=\"plain\">=DATEDIF(A2, TODAY(), &#8220;y&#8221;) &amp; &#8221; Years, &#8221; &amp; DATEDIF(A2, TODAY(), &#8220;ym&#8221;) &amp; &#8221; Months, &#8221; &amp; DATEDIF(A2, TODAY(), &#8220;md&#8221;) &amp; &#8221; Days&#8221;<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Datedif to calculate date difference\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia639879072024-04-07T073A413A34.979688_Datedif_to_calculate_date_difference_3.png\" alt=\"Datedif to calculate date difference\" width=\"1521\" height=\"311\" \/><\/p>\n<p>This command returns a comprehensive age profile\u2014essential for tasks from managing retirement plans to celebrating birthdays.<\/p>\n<p>&nbsp;<\/p>\n<h3>Finding the Tenure Between Two Significant Dates<\/h3>\n<p>Whether you&#8217;re measuring the length of service of an employee or the duration of a lease, computing tenure is a breeze with DATEDIF. By setting up your two key dates in cells A2 (start date) and B2 (end date), the formula you need is:<\/p>\n<div class=\"ql-code-block-container\">\n<div class=\"ql-code-block\" data-language=\"plain\">=DATEDIF(A2, B2, &#8220;y&#8221;) &amp; &#8221; Years, &#8221; &amp; DATEDIF(A2, B2, &#8220;ym&#8221;) &amp; &#8221; Months, &#8221; &amp; DATEDIF(A2, B2, &#8220;md&#8221;) &amp; &#8221; Days&#8221;<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Datedif to calculate date difference\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia639879072024-04-07T073A483A50.844818_Datedif_to_calculate_date_difference_4.png\" alt=\"Datedif to calculate date difference\" width=\"1399\" height=\"353\" \/><\/p>\n<p>This will produce a detailed tenure report showing the years, months, and days that have elapsed between the two dates \u2013 an invaluable figure for those significant milestones.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Advanced_Tips_and_Tricks\"><\/span>Advanced Tips and Tricks<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Combining DATEDIF with Other Functions to calculate date difference<\/h3>\n<p>Of course, real-world scenarios often require even more nuanced date calculations. Excel&#8217;s DATEDIF becomes truly powerful when combined with other functions. For example, integrate DATEDIF with <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/today-formula-in-excel\/\" target=\"_blank\" rel=\"noopener\">TODAY()<\/a> to compute ages or tenure to the current date, or wrap it within an IF statement to handle conditional logic based on the time between dates.<\/p>\n<p>Take this advanced formula for a spin:<\/p>\n<div class=\"ql-code-block-container\">\n<div class=\"ql-code-block\" data-language=\"plain\">=IF(DATEDIF(A2, B2, &#8220;y&#8221;) &gt;= 10, &#8220;Long-term&#8221;, &#8220;Short-term&#8221;)<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Datedif to calculate date difference\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia639879072024-04-07T073A503A37.258904_Datedif_to_calculate_date_difference_5.png\" alt=\"Datedif to calculate date difference\" width=\"945\" height=\"306\" \/><\/p>\n<p>This tells you whether a period (like employment) is more or less than 10 years. It&#8217;s Excel&#8217;s way of customizing data insights to fit your unique requirements.<\/p>\n<h3><\/h3>\n<h3>Troubleshooting Common Errors with DATEDIF<\/h3>\n<p>Even seasoned Excel users can hit snags with DATEDIF, but fear not! Most issues stem from simple oversights. Here&#8217;s how you can identify and fix them:<\/p>\n<p><strong>End Date Before Start Date:<\/strong> Ensure the end_date in <code>=DATEDIF(start_date, end_date, \"unit\")<\/code> is on or after the start_date to avoid a #NUM! error.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Datedif to calculate date difference\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia639879072024-04-07T113A333A36.529994_Datedif_to_calculate_date_difference_6.png\" alt=\"Datedif to calculate date difference\" width=\"597\" height=\"238\" \/><\/p>\n<p><strong>Incorrect Unit Parameter:<\/strong> Wrap the unit argument in double quotes and use the correct abbreviation to instruct Excel properly; otherwise, you may receive an error.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Datedif to calculate date difference\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia639879072024-04-07T113A333A49.827120_Datedif_to_calculate_date_difference_7.png\" alt=\"Datedif to calculate date difference\" width=\"585\" height=\"288\" \/><\/p>\n<p><strong>Date Format Recognition:<\/strong> Excel must recognize your dates as valid. If not formatted correctly as a date, Excel will return a #VALUE! error.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Datedif to calculate date difference\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia639879072024-04-07T113A343A05.276134_Datedif_to_calculate_date_difference_8.png\" alt=\"Datedif to calculate date difference\" width=\"597\" height=\"216\" \/><\/p>\n<p><strong>If Errors Persist:<\/strong> Implement the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-iferror-function\/\" target=\"_blank\" rel=\"noopener\">IFERROR function<\/a> to catch and handle problems dynamically, offering a custom message or a zero instead of an error code.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Datedif to calculate date difference\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia639879072024-04-07T113A343A15.047459_Datedif_to_calculate_date_difference_9.png\" alt=\"Datedif to calculate date difference\" width=\"832\" height=\"243\" \/><\/p>\n<p>Take the habit of double-checking your date formats and arguments, and you&#8217;ll conquer the common pitfalls of DATEDIF with ease.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Enhance_Your_Excel_Skills\"><\/span>Enhance Your Excel Skills<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Streamlining Your Workflow with DATEDIF Shortcuts<\/h3>\n<p>Efficiency in Excel isn&#8217;t just about knowing the right formulas\u2014it&#8217;s also about navigating swiftly. Here&#8217;s a couple of DATEDIF related <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\">shortcuts<\/a> to expedite your workflow:<\/p>\n<ul>\n<li><strong>Quick Date Entry:<\/strong> Press <code>Ctrl + ;<\/code> to insert today&#8217;s date into a selected cell instantly.<\/li>\n<li><strong>AutoFill Handle:<\/strong> After entering your DATEDIF formula, use the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/autofill-formulas-in-an-excel-table\/\" target=\"_blank\" rel=\"noopener\">AutoFill handle<\/a> to drag it down and replicate the formula for adjacent rows, Excel automatically adjusts the cell references.<\/li>\n<\/ul>\n<p>These shortcuts, along with your mastery of DATEDIF, will help you manage date differences with unprecedented speed and accuracy.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"FAQ_Section\"><\/span>FAQ Section<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>What is the primary use of the DATEDIF function in Excel?<\/h3>\n<p>The primary use of the DATEDIF function in Excel is to calculate the difference between two dates based on the interval specified by the user. This interval can be days, months, or years, allowing for versatile date-related calculations such as age in years, months until a future date, or days since an event.<\/p>\n<h3>Can you give an example of how to combine DATEDIF with another function?<\/h3>\n<p>An example of combining DATEDIF with another function is using it alongside the TODAY() function to calculate a person&#8217;s age in years. For instance, =DATEDIF(A1,TODAY(),&#8221;Y&#8221;) would calculate the number of complete years between the date in cell A1 (a person&#8217;s birthdate) and today&#8217;s date, effectively giving the person&#8217;s age.<\/p>\n<h3>How to calculate the date difference between two dates in Excel?<\/h3>\n<p>To calculate the date difference between two dates in Excel, you can simply subtract the earlier date from the later date, such as in =B1-A1, where A1 holds the start date and B1 holds the end date. This subtraction will return the difference in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/dates-between-formula-in-excel\/\" target=\"_blank\" rel=\"noopener\">days between the two dates<\/a>.<\/p>\n<h3>What are the common mistakes when using Datedif()?<\/h3>\n<p>Common mistakes when using the <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c\" target=\"_blank\" rel=\"nofollow noopener\">DATEDIF function in Excel <\/a>include using an end date that is earlier than the start date, which results in an error, and misunderstanding the unit argument (e.g., &#8220;Y&#8221; for years, &#8220;M&#8221; for months, and &#8220;D&#8221; for days), leading to incorrect calculations. Additionally, users sometimes overlook that DATEDIF calculates complete units (years, months, days) between dates, not accounting for partial units, which can lead to confusion when the results are not as expected<\/p>\n<h3>How can I subtract two dates in Excel to find the difference in days?<\/h3>\n<p>To <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/subtract-in-excel\/\" target=\"_blank\" rel=\"noopener\">subtract two dates in Excel<\/a> to find the difference in days, you can use a straightforward subtraction formula, such as =End_Date &#8211; Start_Date. For example, if cell A1 contains the start date and cell B1 contains the end date, the formula =B1-A1 will yield the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-many-days-is-2-months\/\" target=\"_blank\" rel=\"noopener\">number of days<\/a> between the two dates.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Unlock Excel mastery with our DATEDIF guide. Calculate date differences easily and efficiently\u2014perfect for all levels with downloadable examples!<\/p>\n","protected":false},"author":1,"featured_media":42546,"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":[13,294,3],"tags":[2341,2343,59,2342],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/42251"}],"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=42251"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/42251\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/42546"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=42251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=42251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=42251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}