{"id":3053,"date":"2021-07-05T19:40:53","date_gmt":"2021-07-05T14:10:53","guid":{"rendered":"https:\/\/exceltrick.com\/?p=3053"},"modified":"2023-11-08T18:54:29","modified_gmt":"2023-11-08T13:24:29","slug":"excel-weekday-function","status":"publish","type":"post","link":"https:\/\/exceltrick.com\/functions\/excel-weekday-function\/","title":{"rendered":"Excel WEEKDAY Function \u2013 How to Use"},"content":{"rendered":"<p>The WEEKDAY function is a DATE and TIME function that can be used to find the weekday for a given date. The date is supplied to the function as an argument, and consequently, the function returns an integer between 1 \u2013 7, each number representing a day of the week. By default, 1 represents Sunday and 7 represents Saturday, but these values are configurable.<\/p>\n<p>The WEEKDAY function has several uses cases for financial analysts. For instance, think about a capital work-in-process account that requires the addition of labor costs. The financial analyst may be able to estimate this cost simply by computing the anticipated duration for completing the project, removing weekends, and calculating the per-day labor cost for the remainder of the days.<\/p>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-3063\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/07\/Excel-WEEKDAY-Function.png\" alt=\"Excel WEEKDAY Function\" width=\"753\" height=\"396\" title=\"\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_53 counter-hierarchy ez-toc-counter ez-toc-grey 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\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-69f5f843140ff\" ><span class=\"\"><span style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-69f5f843140ff\"  type=\"checkbox\" id=\"item-69f5f843140ff\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/exceltrick.com\/functions\/excel-weekday-function\/#Syntax\" title=\"Syntax\">Syntax<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/exceltrick.com\/functions\/excel-weekday-function\/#Possible_return_type_values\" title=\"Possible &#039;return_type&#039; values\">Possible &#39;return_type&#39; values<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/exceltrick.com\/functions\/excel-weekday-function\/#Important_characteristics_of_the_WEEKDAY_function\" title=\"Important characteristics of the WEEKDAY function\">Important characteristics of the WEEKDAY function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/exceltrick.com\/functions\/excel-weekday-function\/#Examples_of_WEEKDAY_Function\" title=\"Examples of WEEKDAY Function\">Examples of WEEKDAY Function<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/exceltrick.com\/functions\/excel-weekday-function\/#Example_1_%E2%80%93_Plain_Vanilla_Formula_for_the_WEEKDAY_Function\" title=\"Example 1 &#8211; Plain Vanilla Formula for the WEEKDAY Function\">Example 1 &#8211; Plain Vanilla Formula for the WEEKDAY Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/exceltrick.com\/functions\/excel-weekday-function\/#Example_2_%E2%80%93_Configuring_the_WEEKDAY_Function_to_Start_from_Thursday\" title=\"Example 2 &#8211; Configuring the WEEKDAY Function to Start from Thursday\">Example 2 &#8211; Configuring the WEEKDAY Function to Start from Thursday<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/exceltrick.com\/functions\/excel-weekday-function\/#Example_3_%E2%80%93_Display_the_Name_of_Days_Instead_of_Integer_Values\" title=\"Example 3 &#8211; Display the Name of Days Instead of Integer Values\">Example 3 &#8211; Display the Name of Days Instead of Integer Values<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/exceltrick.com\/functions\/excel-weekday-function\/#WEEKDAY_Function_with_Conditional_Formatting\" title=\"WEEKDAY Function with Conditional Formatting\">WEEKDAY Function with Conditional Formatting<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/exceltrick.com\/functions\/excel-weekday-function\/#Use_WEEKDAY_Function_for_Calculating_Wages_at_Different_Rates\" title=\"Use WEEKDAY Function for Calculating Wages at Different Rates\">Use WEEKDAY Function for Calculating Wages at Different Rates<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Syntax\"><\/span>Syntax<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The syntax of the WEEKDAY function is as follows:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">WEEKDAY<\/span>(serial_number, [return_type])<\/code><\/div>\n<p style=\"margin: 0px;\"><strong>Arguments:<\/strong><\/p>\n<p style=\"padding-left: 30px;\"><code>serial_number<\/code> &#8211; This is a required argument that may be supplied with either the serial number or a cell reference to the date for which we want to find the day.<\/p>\n<p style=\"padding-left: 30px;\"><code>return_type<\/code> &#8211; This is an optional argument and is set to 1 by default, i.e., the first day is set to Sunday. Alternatively, we may use the table illustrated below for specifying which day of the week we want to consider as day 1.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Possible_return_type_values\"><\/span>Possible &#39;return_type&#39; values<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<table class=\"tableizer-table\">\n<thead>\n<tr class=\"tableizer-firstrow\">\n<th>&#39;return_type&#39; value<\/th>\n<th>Day Represented by &#39;return_type&#39;<\/th>\n<th>Numerical Result<\/th>\n<th>Numerical Result Day Mapping<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>none (default)<\/td>\n<td>Sunday<\/td>\n<td>1-7<\/td>\n<td>Sunday-Saturday<\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>Sunday<\/td>\n<td>1-7<\/td>\n<td>Sunday-Saturday<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Monday<\/td>\n<td>1-7<\/td>\n<td>Monday-Sunday<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Tuesday<\/td>\n<td>0-6 (since Monday = 0 in this case)<\/td>\n<td>Monday-Sunday<\/td>\n<\/tr>\n<tr>\n<td>11<\/td>\n<td>Monday<\/td>\n<td>1-7<\/td>\n<td>Monday-Sunday<\/td>\n<\/tr>\n<tr>\n<td>12<\/td>\n<td>Tuesday<\/td>\n<td>1-7<\/td>\n<td>Tuesday-Monday<\/td>\n<\/tr>\n<tr>\n<td>13<\/td>\n<td>Wednesday<\/td>\n<td>1-7<\/td>\n<td>Wednesday-Tuesday<\/td>\n<\/tr>\n<tr>\n<td>14<\/td>\n<td>Thursday<\/td>\n<td>1-7<\/td>\n<td>Thursday-Wednesday<\/td>\n<\/tr>\n<tr>\n<td>15<\/td>\n<td>Friday<\/td>\n<td>1-7<\/td>\n<td>Friday-Thursday<\/td>\n<\/tr>\n<tr>\n<td>16<\/td>\n<td>Saturday<\/td>\n<td>1-7<\/td>\n<td>Saturday-Friday<\/td>\n<\/tr>\n<tr>\n<td>17<\/td>\n<td>Sunday<\/td>\n<td>1-7<\/td>\n<td>Sunday-Saturday<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"Important_characteristics_of_the_WEEKDAY_function\"><\/span>Important characteristics of the WEEKDAY function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>The WEEKDAY function returns 1 for Sunday (and 7 for Saturday) by default when the <em>return_type<\/em> argument is left empty.<\/li>\n<li>If the <em>serial_number <\/em>argument is empty, the WEEKDAY function still returns &#39;7.&#39;<\/li>\n<li>If the value supplied in the <em>serial_number<\/em> argument is non-numeric, the function returns a #VALUE error.<\/li>\n<li>If the <em>serial_number<\/em> argument falls outside of Excel&#39;s database or the <em>return_type <\/em>argument is unrecognized (i.e., isn&#39;t empty, 1\u20133, or 11\u201317), then the function returns a #NUM error.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Examples_of_WEEKDAY_Function\"><\/span>Examples of WEEKDAY Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Let\u2019s try to see some examples of the WEEKDAY function.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Example_1_%E2%80%93_Plain_Vanilla_Formula_for_the_WEEKDAY_Function\"><\/span>Example 1 &#8211; Plain Vanilla Formula for the WEEKDAY Function<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Let&#39;s start with the basic WEEKDAY formula. All we want to do here is have the WEEKDAY function tell us which day it is for a set of dates we supply.<\/p>\n<p>We&#39;ll use the following formula.<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">WEEKDAY<\/span>(A2)<\/code><\/div>\n<img decoding=\"async\" class=\"aligncenter wp-image-3064 size-full\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/07\/Excel-WeekDay-Function-Example-01.png\" alt=\"Plain Vanilla Formula for the WEEKDAY Function\" width=\"577\" height=\"213\" title=\"\">\n<p>So, we have our output as 3, 3, 5, and 1 which we know means Tue, Tue, Thu, and Sun. We&#39;re just warming up here. Let&#39;s tweak this formula a little.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Example_2_%E2%80%93_Configuring_the_WEEKDAY_Function_to_Start_from_Thursday\"><\/span>Example 2 &#8211; Configuring the WEEKDAY Function to Start from Thursday<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>As mentioned while discussing the syntax, we can configure the WEEKDAY function to set any day as day 1. We&#39;ll need to refer to the table showing the <em>return_type <\/em>values, and check which value we need to use to set a day of our choice as the first day. In our case, we want Thursday as our day 1. Therefore, we&#39;ll use 14 in the <em>return_type<\/em> argument, like so:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">WEEKDAY<\/span>(A2, 14)<\/code><\/div>\n<img decoding=\"async\" class=\"aligncenter wp-image-3065 size-full\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/07\/Excel-WeekDay-Function-Example-02.png\" alt=\"Configuring the WEEKDAY Function to Start from Thursday\" width=\"893\" height=\"248\" title=\"\">\n<p>Since Thu is Sunday + 3 days, notice that all output values are greater by 3 than the output values of our previous example. Also, note that March 31, 2002, is actually a Sunday. Since we have now set Thursday as day 1, the output is 4 (i.e., 4 days from Thursday), which is Sunday.<\/p>\n<p>Child&#39;s play, isn&#39;t it?<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Example_3_%E2%80%93_Display_the_Name_of_Days_Instead_of_Integer_Values\"><\/span>Example 3 &#8211; Display the Name of Days Instead of Integer Values<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel sheets are already numerically intense. Any opportunity we have to use text is a Godsend. As you see in the previous examples, the WEEKDAY function always gives us a number between 1\u20137 and the onus is on us to check which day the number represents. This is especially true for example 2 where we set Thursday as our day 1.<\/p>\n<p>However, we can remedy this using the <a href=\"https:\/\/exceltrick.com\/functions\/excel-choose-function\/\"  rel=\"noopener\">CHOOSE function<\/a>. This is the formula we will use:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">CHOOSE<\/span>(<span class=\"function\">WEEKDAY<\/span>(A2, 14), \"<span class=\"string\">Thu<\/span>\", \"<span class=\"string\">Fri<\/span>\", \"<span class=\"string\">Sat<\/span>\", \"<span class=\"string\">Sun<\/span>\", \"<span class=\"string\">Mon<\/span>\", \"<span class=\"string\">Tue<\/span>\", \"<span class=\"string\">Wed<\/span>\")<\/code><\/div>\n<img decoding=\"async\" class=\"aligncenter wp-image-3066 size-full\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/07\/Excel-WeekDay-Function-Example-03.png\" alt=\"Display the Name of Days Instead of Integer Values\" width=\"782\" height=\"248\" title=\"\">\n<p>It&#39;s pretty obvious what the formula does, correct? If it&#39;s not clear, let me break it down. The CHOOSE function uses the value relayed by the WEEKDAY function as an index and outputs the value in (n+1)<sup>th<\/sup> comment. For instance, if the WEEKDAY function relays 2, the CHOOSE function returns the 3<sup>rd<\/sup> (2+1) comment which is &quot;Fri&quot;.<\/p>\n<p>As you can see, our output checks out with our previous example. We&#39;re only just getting started with the cool stuff we can do with the WEEKDAY function. Alright, on to the next one.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"WEEKDAY_Function_with_Conditional_Formatting\"><\/span>WEEKDAY Function with Conditional Formatting<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>We all know the happiness of delivering a successful project. And for a project to be really successful, it must be delivered within the deadlines. So project managers are under the constant stress of meeting the project deadlines.<\/p>\n<p>One such manager has been making attempts to see how many days during the project timeline are weekends. Since those days are off for the employees anyway, they can be overlooked while coming up with an action plan for tackling deadlines.<\/p>\n<p>Let&#39;s help him with this, shall we?<\/p>\n<p>Here&#39;s the formula we will use to help the manager find out if a day is a Weekend or a Working Day.<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">IF<\/span>((<span class=\"function\">WEEKDAY<\/span>(A2, 2) <span class=\"operator\">&lt;<\/span> 6),\"<span class=\"string\">Working Day<\/span>\",\"<span class=\"string\">Weekend<\/span>\")<\/code><\/div>\n<p>You&#39;ll see all the dates are now categorized either as a working day or weekend.<\/p>\n<img decoding=\"async\" class=\"aligncenter wp-image-3067 size-full\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/07\/Excel-WeekDay-Function-Example-04a.png\" alt=\"WEEKDAY Function with Conditional Formatting\" width=\"604\" height=\"478\" title=\"\">\n<p>In this formula, the WEEKDAY function checks the date in column A with return_type as 2. This means that instead of Sunday first day is set as Monday. Based on this logic, Saturday becomes 6 and Sunday becomes 7. Outside we have an <a href=\"https:\/\/exceltrick.com\/functions\/excel-if-statement\/\"  rel=\"noopener\">IF function<\/a> that checks if the result of the WEEKDAY function is less than 6, then display &quot;Working Day&quot;, otherwise display &quot;Weekend&quot;.<\/p>\n<p>The formula does the job, but there&#39;s a way to improve this output aesthetically. Let&#39;s play around with some <a href=\"https:\/\/exceltrick.com\/what-is\/conditional-formatting\/\">conditional formatting<\/a> to achieve a more polished output.<\/p>\n<p>To do this, select the output range and go to Home &gt; Styles &gt; Conditional Formatting &gt; New rule. This should open a dialog box. Select &quot;Use a formula to determine which cells to format&quot; as the rule type.<\/p>\n<img decoding=\"async\" class=\"aligncenter wp-image-3068 size-full\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/07\/Excel-WeekDay-Function-Example-04b.png\" alt=\"Use a formula to determine which cells to format\" width=\"757\" height=\"530\" title=\"\">\n<p>At the bottom of the dialog box, insert the following formula:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">WEEKDAY<\/span>($A2, 2) <span class=\"operator\">&gt;<\/span> 5<\/code><\/div>\n<p>Next, click on the Format button and head over to the Fill tab. Choose the color &quot;green&quot; (or any other color of your choice) and click OK. Click OK again to close the conditional formatting dialog box.<\/p>\n<img decoding=\"async\" class=\"aligncenter wp-image-3069 size-full\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/07\/Excel-WeekDay-Function-Example-04c.png\" alt=\"you should see all the Weekends highlighted in green\" width=\"607\" height=\"485\" title=\"\">\n<p>When you&#39;re done, you should see all the Weekends highlighted in green.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Use_WEEKDAY_Function_for_Calculating_Wages_at_Different_Rates\"><\/span>Use WEEKDAY Function for Calculating Wages at Different Rates<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Based on the above scenario, the manager comes to the conclusion that he does not have enough work days to deliver the project on time. To tackle this, he needs to request any one of the employees to work on weekends as well till the first phase of delivery.<\/p>\n<p>It&#39;s only fair to offer the employee a higher wage for the weekend, wouldn&#39;t you agree? There&#39;s just one hiccup \u2013 how do you calculate the total wages for the employee far more conveniently rather than doing all the work manually?<\/p>\n<p>We can have Excel make these computations for us using the IF function and the WEEKDAY function, like so:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">IF<\/span>(<span class=\"function\">WEEKDAY<\/span>(A3, 2) <span class=\"operator\">&gt;<\/span> 5, C3<span class=\"operator\">*<\/span>$G$8,C3<span class=\"operator\">*<\/span>$G$7)<\/code><\/div>\n<img decoding=\"async\" class=\"aligncenter wp-image-3070 size-full\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2021\/07\/Excel-WeekDay-Function-Example-05.png\" alt=\"Use WEEKDAY Function for Calculating Wages at Different Rates\" width=\"856\" height=\"525\" title=\"\">\n<p>Let&#39;s put this formula in words. Essentially, the formula checks what the output value is for the WEEKDAY function. If it&#39;s equal to 6 or 7 (i.e., it is Saturday or Sunday), it multiplies the number of hours worked (from cell C3) with the premium rate mentioned in cell G7. If the value is equal to 1, 2, 3, 4, or 5 (i.e., it is a working day), the value in C3 is multiplied by the usual rate in cell G8.<\/p>\n<p>Once we have the day-wise wages calculated for the employee, we can use the SUM function to calculate the total wages payable for the month, like so:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">SUM<\/span>(D3:D17)<\/code><\/div>\n<p>So, the total wages payable to the employee is $ 3,900.00 in our example.<\/p>\n<p>That wraps up the WEEKDAY function. It allows you to do plenty of cool things, can often come in handy with its unique use-cases, and saves you a ton of time. Keep practicing this highly utilitarian function, and when you&#39;re done, we&#39;ll have the next function loaded for you ready to fire away!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The WEEKDAY function is a DATE and TIME function that can be used to find the weekday for a given date. The date is supplied to the function as an argument, and consequently, the function returns an integer between 1 \u2013 7, each number representing a day of the week. By default, 1 represents Sunday [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":3063,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[32],"_links":{"self":[{"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/posts\/3053"}],"collection":[{"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/comments?post=3053"}],"version-history":[{"count":0,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/posts\/3053\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/media\/3063"}],"wp:attachment":[{"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/media?parent=3053"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/categories?post=3053"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/tags?post=3053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}