{"id":388031,"date":"2021-12-31T19:00:38","date_gmt":"2021-12-31T16:00:38","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-find-the-day-of-the-week-from-a-date-in-microsoft-excel\/"},"modified":"2021-12-31T19:00:38","modified_gmt":"2021-12-31T16:00:38","slug":"how-to-find-the-day-of-the-week-from-a-date-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-find-the-day-of-the-week-from-a-date-in-microsoft-excel\/","title":{"rendered":"#How to Find the Day of the Week From a Date in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a4266ef545f6\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" 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: #dd3333;color:#dd3333\" 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 type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a4266ef545f6\" checked aria-label=\"Toggle\" \/><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:\/\/buradabiliyorum.com\/en\/how-to-find-the-day-of-the-week-from-a-date-in-microsoft-excel\/#Ways_to_Find_the_Weekday_From_a_Date_in_Excel\" >Ways to Find the Weekday From a Date in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-the-day-of-the-week-from-a-date-in-microsoft-excel\/#Find_the_Day_of_the_Week_as_a_Number\" >Find the Day of the Week as a Number<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-the-day-of-the-week-from-a-date-in-microsoft-excel\/#Find_the_Day_of_the_Week_as_a_Name\" >Find the Day of the Week as a Name<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-the-day-of-the-week-from-a-date-in-microsoft-excel\/#Convert_Dates_to_Days_of_the_Week\" >Convert Dates to Days of the Week<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Find the Day of the Week From a Date in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Do you have a date in your spreadsheet that you want to turn into the day of the week? If so, Microsoft Excel has multiple features and functions to help you do that. We\u2019ll show you how to use them.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Ways_to_Find_the_Weekday_From_a_Date_in_Excel\"><\/span>Ways to Find the Weekday From a Date in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To find the day of the week from a date, you have basically three ways. The first method is to turn your date into the day of the week in a numerical form. In this method, Sunday is displayed as number 1, Monday is number 2, and so on. This is calculated with Excel\u2019s WEEKDAY function.<\/p>\n<p>The second method displays the actual name of the day of week, like Sunday, Monday, and so on. This method uses Excel\u2019s <code>TEXT<\/code> function that <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/415246\/how-to-convert-text-to-date-values-in-microsoft-excel\/\">converts your date to the day format.<\/p>\n<p>The third method re-formats your actual dates and displays them as the names of the day of week, like Sunday, Monday, and so on. If you use this method, you do not need a separate column to display the days, as your existing date is overwritten.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Find_the_Day_of_the_Week_as_a_Number\"><\/span>Find the Day of the Week as a Number<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To find the day of the week as a number, use Excel\u2019s <code>WEEKDAY<\/code> function as follows. The count starts from Sunday, where it is numbered 1. However, you can make the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/761846\/how-to-find-the-function-you-need-in-microsoft-excel\/\">function count from any chosen day (like Monday), as we\u2019ll explain below.<\/p>\n<p>To start, first, open your spreadsheet with Microsoft Excel. In the spreadsheet, make sure you have at least one date. Then select the cell in which you want to display the day of the week.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-769662\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/1-select-cell-2.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a cell in an Excel spreadsheet.\" width=\"595\" height=\"321\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the selected cell, type the following <code>WEEKDAY<\/code> function and press Enter. In this function, replace <code>B2<\/code> with the cell where you have your date.<\/p>\n<pre>=WEEKDAY(B2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-769663\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/2-enter-weekday-function.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter the WEEKDAY function.\" width=\"588\" height=\"322\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019d like to use the date directly in the function, type the following <code>WEEKDAY<\/code> function with your date in it and press Enter. Keep double quotes around your date.<\/p>\n<pre>=WEEKDAY(\"24\/5\/2021\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-769664\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/3-direct-values-weekday-function.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter the WEEKDAY function with direct values.\" width=\"650\" height=\"296\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And in the selected cell, you will see the day of the week for your date as a number.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-769665\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/4-weekday-function-result.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"The result of the WEEKDAY function.\" width=\"577\" height=\"322\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To make the function count days so that Monday is number 1, modify the function as follows. The number <code>2<\/code> in the function argument tells it to start counting from Monday.<\/p>\n<pre>=WEEKDAY(B2,2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-769666\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/5-custom-weekday-function.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Type the custom WEEKDAY function.\" width=\"565\" height=\"296\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Here\u2019s how your result now looks like:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-769667\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/6-custom-weekday-function-result.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"The result of the custom WEEKDAY function.\" width=\"579\" height=\"293\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To copy the function to other cells, drag downwards from the bottom-right corner of the cell where you typed the function.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-769668\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/7-copy-weekday-function.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Copy the WEEKDAY function.\" width=\"620\" height=\"325\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Sort by Date in Microsoft Excel<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Find_the_Day_of_the_Week_as_a_Name\"><\/span>Find the Day of the Week as a Name<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To display a date\u2019s day of the week as the day name, like Monday, use Excel\u2019s <code>TEXT<\/code> function. In this function, you tell Excel to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/761403\/how-to-change-date-formats-in-microsoft-excel\/\">format your date in the day format. You can choose the shortened day name (like Mon) or full day name (like Monday).<\/p>\n<p>Start by opening your spreadsheet with Microsoft Excel. Then select the cell in which you want to display the day of week.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-769669\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/8-choose-cell.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click a cell in an Excel spreadsheet.\" width=\"585\" height=\"292\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the selected cell, type the following <code>TEXT<\/code> function and press Enter. In this function, replace <code>B2<\/code> with the cell where your date is.<\/p>\n<pre>=TEXT(B2,\"dddd\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-769670\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/9-enter-text-function.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter the TEXT function.\" width=\"594\" height=\"294\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The selected cell will display the day of the week. If you\u2019d prefer a shortened day name, like \u201cMon\u201d for Monday, remove one <code>d<\/code> from the function argument as follows:<\/p>\n<pre>=TEXT(B2,\"ddd\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-769671\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/10-custom-text-function.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Type the custom TEXT function.\" width=\"581\" height=\"292\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And you now have the shortened day name in your selected cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-769672\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/11-text-function-result.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"The result of the custom TEXT function.\" width=\"579\" height=\"319\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Depending on how you like to style your sheets, you may want to format your dates using periods in Excel.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Convert_Dates_to_Days_of_the_Week\"><\/span>Convert Dates to Days of the Week<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To convert your dates to days of weeks without <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/450927\/how-to-make-one-long-column-into-multiple-columns-in-excel\/\">using a separate column, use Excel\u2019s custom number format. This displays the day of week by its full or shortened name.<\/p>\n<p>To do so, first, open your spreadsheet with Microsoft Excel. Then select the cells containing dates.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-769673\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/12-select-dates.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the date cells.\" width=\"534\" height=\"323\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In Excel\u2019s ribbon at the top, click the \u201cHome\u201d tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-769674\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/13-excel-home-tab.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the &quot;Home&quot; tab in Excel.\" width=\"548\" height=\"195\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the \u201cHome\u201d tab, from the \u201cNumber\u201d section, select \u201cNumber Format\u201d (an arrow icon).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-769675 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/14-excel-number-format.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select &quot;Number Format&quot; in the &quot;Home&quot; tab.\" width=\"507\" height=\"278\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>A \u201cFormat Cells\u201d window will open. On this window, from the \u201cCategory\u201d list on the left, select \u201cCustom.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-769676 size-full\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/15-custom-number-format.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select &quot;Custom&quot; on the &quot;Format Cells&quot; window.\" width=\"650\" height=\"437\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>On the right, click the \u201cType\u201d box and enter \u201cdddd\u201d (without quotes) for full day names (like Monday) or \u201cddd\u201d for shortened day names (like Mon). Then, at the bottom, click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-769678\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/16-enter-number-format.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Specify the date format.\" width=\"506\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Excel will turn your selected dates into days of the week.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-769679\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/17-number-format-result.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Dates turned into days of week.\" width=\"434\" height=\"325\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And that\u2019s how you know what day it was on a specific date in Microsoft Excel. Very useful!<\/p>\n<hr\/>\n<p>Did you know you can use Excel to calculate someone\u2019s age, too? It\u2019s equally easy to do that.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Calculate Age in Microsoft Excel<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/769657\/how-to-find-the-day-of-the-week-from-a-date-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Find the Day of the Week From a Date in Microsoft Excel&#8221; Do you have a date in your spreadsheet that you want to turn into the day of the week? If so, Microsoft Excel has multiple features and functions to help you do that. We\u2019ll show you how to use them. Ways&#8230;<\/p>\n","protected":false},"author":1,"featured_media":388032,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-388031","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/388031","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=388031"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/388031\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/388032"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=388031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=388031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=388031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}