{"id":58,"date":"2022-09-19T22:41:45","date_gmt":"2022-09-19T22:41:45","guid":{"rendered":"https:\/\/www.tiposaurus.co.uk\/?p=58"},"modified":"2024-01-26T23:22:34","modified_gmt":"2024-01-26T23:22:34","slug":"display-the-weekday-as-text-in-excel","status":"publish","type":"post","link":"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/","title":{"rendered":"Display the Weekday as Text in Excel"},"content":{"rendered":"<p>I often want to know what day of the week a date is. The obvious choice in Excel is the <code>WEEKDAY()<\/code> function for this; however it only returns an integer. For example, the formula: <code>=WEEKDAY(\"01\/02\/2009\")<\/code> returns <code>1<\/code> (which represents Sunday). In this article, I&#8217;ll describe the various ways which you can display the weekday as text in Excel.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 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\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" 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><\/span><\/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:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/#The_TEXT_function\" title=\"The TEXT() function\">The TEXT() function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/#Display_Weekday_as_Text_in_Excel_using_VBA_Script\" title=\"Display Weekday as Text in Excel using VBA Script\">Display Weekday as Text in Excel using VBA Script<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/#Nested_IF\" title=\"Nested IF()\">Nested IF()<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"The_TEXT_function\"><\/span>The TEXT() function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The easiest way to do this is via the <code>TEXT()<\/code> function, which you pass the date you want to show the weekday of, and a text code representing how you want it displayed. If the date is in cell <code>A1<\/code>, some possibilities are:<\/p>\n<ul>\n<li><code>=TEXT(A1, \"ddd\")<\/code> &#8211; which will show the date as <code>Sat<\/code>, <code>Sun<\/code>, <code>Mon<\/code>, etc<\/li>\n<li><code>=TEXT(A1, \"dddd\")<\/code> &#8211; will show the date as <code>Saturday<\/code>, <code>Sunday<\/code>, <code>Monday<\/code>, and so on.<\/li>\n<li>Other options are available, including <code>\"mmm\"<\/code> for month names (and the <code>TEXT()<\/code> function is handy for formatting things other than dates) &#8211; see the <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c\">TEXT() function help page<\/a> for more information.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Display_Weekday_as_Text_in_Excel_using_VBA_Script\"><\/span>Display Weekday as Text in Excel using VBA Script<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If the <code>TEXT()<\/code> function isn&#8217;t flexible enough, you can use write a VBA User Defined Function to display it in the way you want. We&#8217;ve included an example below.<\/p>\n<p>The function (note that this is not the most elegant implementation possible, but the code is highly readable) is:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">' function to return a text representation of the weekday of a given date\r\n' returns the full text, which can be shortened by left(), etc\r\nFunction dayText(d As Date) As String\r\n  If Weekday(d) = 1 Then dayText = \"Sunday\"\r\n  If Weekday(d) = 2 Then dayText = \"Monday\"\r\n  If Weekday(d) = 3 Then dayText = \"Tuesday\"\r\n  If Weekday(d) = 4 Then dayText = \"Wednesday\"\r\n  If Weekday(d) = 5 Then dayText = \"Thursday\"\r\n  If Weekday(d) = 6 Then dayText = \"Friday\"\r\n  If Weekday(d) = 7 Then dayText = \"Saturday\"\r\nEnd Function<\/pre>\n<p>Enter this via the VBA Editor &#8211; press Alt + F11, then Insert -&gt; Module and paste this code in. You may wish to add in validation, such as ensuring it can properly handle bad data, such as blank cells or inputs which are not dates.<\/p>\n<p>It can then be called by:<\/p>\n<p><code>=DAYTEXT(\"01\/02\/2009\")<\/code><\/p>\n<p>which returns <code>Sunday<\/code>.<\/p>\n<p>This can then be shortened to one or three letters via the <code>LEFT()<\/code> function, for example:<\/p>\n<p><code>=LEFT(DAYTEXT(\"01\/02\/2009\"),3)<\/code><\/p>\n<p>returns <code>Sun<\/code>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nested_IF\"><\/span>Nested IF()<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to avoid macros, an alternative method to displaying the weekday as text in Excel is to use the (slightly messy) formula consisting of nested <code>IF()<\/code>, for a spreadsheet with a date in cell <code>A1<\/code>:<\/p>\n<p><code>=IF(WEEKDAY(A1)=1, \"Sunday\", IF(WEEKDAY(A1)=2,\"Monday\",IF(WEEKDAY(A1)=3, \"Tuesday\", IF(WEEKDAY(A1)=4, \"Wednesday\", IF(WEEKDAY(A1)=5, \"Thursday\", IF(WEEKDAY(A1)=6, \"Friday\", \"Saturday\"))))))<\/code><\/p>\n<p>This returns the same as the VBA script above.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I often want to know what day of the week a date is. The obvious choice in Excel is the WEEKDAY() function for this; however it only returns an integer. For example, the formula: =WEEKDAY(&#8220;01\/02\/2009&#8221;) returns 1 (which represents Sunday). In this article, I&#8217;ll describe the various ways which you can display the weekday as &#8230; <a title=\"Display the Weekday as Text in Excel\" class=\"read-more\" href=\"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/\" aria-label=\"More on Display the Weekday as Text in Excel\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Display the Weekday as Text in Excel - Tiposaurus<\/title>\n<meta name=\"description\" content=\"How to display the weekday as text in Excel, using various different methods to produce the output you need.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Display the Weekday as Text in Excel - Tiposaurus\" \/>\n<meta property=\"og:description\" content=\"How to display the weekday as text in Excel, using various different methods to produce the output you need.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tiposaurus\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-19T22:41:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-26T23:22:34+00:00\" \/>\n<meta name=\"author\" content=\"Steven\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Steven\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/\"},\"author\":{\"name\":\"Steven\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c\"},\"headline\":\"Display the Weekday as Text in Excel\",\"datePublished\":\"2022-09-19T22:41:45+00:00\",\"dateModified\":\"2024-01-26T23:22:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/\"},\"wordCount\":324,\"publisher\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#organization\"},\"articleSection\":[\"Excel\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/\",\"name\":\"Display the Weekday as Text in Excel - Tiposaurus\",\"isPartOf\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#website\"},\"datePublished\":\"2022-09-19T22:41:45+00:00\",\"dateModified\":\"2024-01-26T23:22:34+00:00\",\"description\":\"How to display the weekday as text in Excel, using various different methods to produce the output you need.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.tiposaurus.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Display the Weekday as Text in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#website\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/\",\"name\":\"Tiposaurus\",\"description\":\"Technology, Productivity and Development\",\"publisher\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.tiposaurus.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#organization\",\"name\":\"Tiposaurus\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png\",\"contentUrl\":\"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png\",\"width\":133,\"height\":97,\"caption\":\"Tiposaurus\"},\"image\":{\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c\",\"name\":\"Steven\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g\",\"caption\":\"Steven\"},\"sameAs\":[\"https:\/\/www.tiposaurus.co.uk\"],\"url\":\"https:\/\/www.tiposaurus.co.uk\/author\/steven\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Display the Weekday as Text in Excel - Tiposaurus","description":"How to display the weekday as text in Excel, using various different methods to produce the output you need.","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.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/","og_locale":"en_GB","og_type":"article","og_title":"Display the Weekday as Text in Excel - Tiposaurus","og_description":"How to display the weekday as text in Excel, using various different methods to produce the output you need.","og_url":"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/","og_site_name":"Tiposaurus","article_published_time":"2022-09-19T22:41:45+00:00","article_modified_time":"2024-01-26T23:22:34+00:00","author":"Steven","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Steven","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/"},"author":{"name":"Steven","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c"},"headline":"Display the Weekday as Text in Excel","datePublished":"2022-09-19T22:41:45+00:00","dateModified":"2024-01-26T23:22:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/"},"wordCount":324,"publisher":{"@id":"https:\/\/www.tiposaurus.co.uk\/#organization"},"articleSection":["Excel"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/","url":"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/","name":"Display the Weekday as Text in Excel - Tiposaurus","isPartOf":{"@id":"https:\/\/www.tiposaurus.co.uk\/#website"},"datePublished":"2022-09-19T22:41:45+00:00","dateModified":"2024-01-26T23:22:34+00:00","description":"How to display the weekday as text in Excel, using various different methods to produce the output you need.","breadcrumb":{"@id":"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.tiposaurus.co.uk\/display-the-weekday-as-text-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.tiposaurus.co.uk\/"},{"@type":"ListItem","position":2,"name":"Display the Weekday as Text in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.tiposaurus.co.uk\/#website","url":"https:\/\/www.tiposaurus.co.uk\/","name":"Tiposaurus","description":"Technology, Productivity and Development","publisher":{"@id":"https:\/\/www.tiposaurus.co.uk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.tiposaurus.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.tiposaurus.co.uk\/#organization","name":"Tiposaurus","url":"https:\/\/www.tiposaurus.co.uk\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/","url":"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png","contentUrl":"https:\/\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/12\/cropped-cropped-tiposaurus-logo-small-e1702978467185.png","width":133,"height":97,"caption":"Tiposaurus"},"image":{"@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/94552b25c2fb53129269a0474088930c","name":"Steven","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.tiposaurus.co.uk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/70dad3cfd851615162ae18a230e533e3?s=96&d=mm&r=g","caption":"Steven"},"sameAs":["https:\/\/www.tiposaurus.co.uk"],"url":"https:\/\/www.tiposaurus.co.uk\/author\/steven\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":130,"url":"https:\/\/www.tiposaurus.co.uk\/excel-minifs-function\/","url_meta":{"origin":58,"position":0},"title":"How to use MINIFS in Excel","author":"Steven","date":"August 30, 2022","format":false,"excerpt":"You'll likely be familiar with the MIN function for taking the value of a range: MIN(A1:A5) will return the minimum value in cells A1:A5.\u00a0 If you need to take a conditional minimum, which applies to only some of the values in that range, without splitting your data up, then the\u2026","rel":"","context":"In &quot;Functions&quot;","block_context":{"text":"Functions","link":"https:\/\/www.tiposaurus.co.uk\/category\/functions\/"},"img":{"alt_text":"example example and uses of MINIFS","src":"https:\/\/i0.wp.com\/www.excelfinancemastery.com\/wp-content\/uploads\/2022\/08\/1.-minifs-data-e1661470827100.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":71,"url":"https:\/\/www.tiposaurus.co.uk\/the-dictionary-object-in-excel-vba-definitive-guide\/","url_meta":{"origin":58,"position":1},"title":"The Dictionary Object in Excel VBA &#8211; Definitive Guide","author":"Steven","date":"April 11, 2023","format":false,"excerpt":"1. Introduction This guide aims to provide a comprehensive understanding of the Dictionary object in Excel VBA, including an overview of its features and the advantages it offers over other data structures like arrays and collections. We will also cover how to include the necessary library, create a dictionary, add\u2026","rel":"","context":"In &quot;VBA&quot;","block_context":{"text":"VBA","link":"https:\/\/www.tiposaurus.co.uk\/category\/vba\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":132,"url":"https:\/\/www.tiposaurus.co.uk\/how-to-use-maxifs-in-excel\/","url_meta":{"origin":58,"position":2},"title":"How to use MAXIFS in Excel","author":"Steven","date":"March 20, 2023","format":false,"excerpt":"MAXIFS is a function in Excel that allows you to find the maximum value in a range that meets specific criteria. It's an extremely useful function when dealing with large sets of data, as it allows you to quickly and easily identify the highest value that meets certain conditions. This\u2026","rel":"","context":"In &quot;Functions&quot;","block_context":{"text":"Functions","link":"https:\/\/www.tiposaurus.co.uk\/category\/functions\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":82,"url":"https:\/\/www.tiposaurus.co.uk\/generate-a-month-calendar-in-php\/","url_meta":{"origin":58,"position":3},"title":"Generate a Month Calendar in PHP","author":"Steven","date":"March 22, 2023","format":false,"excerpt":"This article shows you how to display a calendar for a given month, mainly using PHP's date() function. The date() function The date() function displays the date in your desired format, at a given time. It works by accepting one or two parameters, the first is a string with the\u2026","rel":"","context":"In &quot;PHP&quot;","block_context":{"text":"PHP","link":"https:\/\/www.tiposaurus.co.uk\/category\/archive\/php\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.tiposaurus.co.uk\/wp-content\/uploads\/2023\/03\/output-248x300.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":91,"url":"https:\/\/www.tiposaurus.co.uk\/dynamically-add-text-to-an-image-in-php\/","url_meta":{"origin":58,"position":4},"title":"Dynamically Add Text to Image in PHP","author":"Steven","date":"March 23, 2023","format":false,"excerpt":"This tutorial will tell you how to dynamically write text to an image in PHP. This is fairly simple, so it will just be the first step in a series of tutorials dealing with images in PHP. The image functions require the GD library to be installed. Adding text to\u2026","rel":"","context":"In &quot;PHP&quot;","block_context":{"text":"PHP","link":"https:\/\/www.tiposaurus.co.uk\/category\/archive\/php\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":135,"url":"https:\/\/www.tiposaurus.co.uk\/how-to-calculate-net-present-values-in-excel\/","url_meta":{"origin":58,"position":5},"title":"How to Calculate Net Present Values in Excel","author":"Steven","date":"April 11, 2023","format":false,"excerpt":"Introduction Net Present Value (NPV) is a widely used financial metric that helps investors and business managers to evaluate the profitability of an investment or project. NPV calculates the difference between the present value of cash inflows and the present value of cash outflows over a certain period. A positive\u2026","rel":"","context":"In &quot;Excel&quot;","block_context":{"text":"Excel","link":"https:\/\/www.tiposaurus.co.uk\/category\/archive\/excel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts\/58"}],"collection":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/comments?post=58"}],"version-history":[{"count":5,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts\/58\/revisions"}],"predecessor-version":[{"id":63,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/posts\/58\/revisions\/63"}],"wp:attachment":[{"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/media?parent=58"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/categories?post=58"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tiposaurus.co.uk\/wp-json\/wp\/v2\/tags?post=58"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}