{"id":1793,"date":"2011-10-17T14:25:56","date_gmt":"2011-10-17T14:25:56","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=436"},"modified":"2023-12-30T23:13:14","modified_gmt":"2023-12-30T23:13:14","slug":"excel-tips-calculate-the-weekday-from-a-date","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/excel-tips-calculate-the-weekday-from-a-date\/","title":{"rendered":"Excel Tips: Calculate the weekday from a date"},"content":{"rendered":"<p>You can display the weekday for dates stored in Excel.\u00a0 This is especially useful for checking if due dates fall during the working week.\u00a0 To do this you need to use the weekday function and custom formatting features of Excel.\u00a0 The screenshot below are from Excel 2010, but this work in earlier versions too.<\/p>\n<ul>\n<li>Ensure the date on your spreadsheet is formatted as a date<\/li>\n<li>Insert the weekday function<\/li>\n<li>The weekday function has two arguments \u2013 the date (or cell where the date is and a return type.\u00a0 The return type is optional and for this to work correctly should be left blank.\u00a0<a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/weekday1.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-437\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/weekday1.png\" alt=\"\" width=\"630\" height=\"359\" \/><\/a><\/li>\n<li>Format the cell using custom formatting \u2013 to do this you will need to open the format cells dialog box, Ctrl+1 is a keyboard shortcut to do this which works in all Excel versions.<\/li>\n<\/ul>\n<p>On the Number tab, choose Custom and in the Type box enter <strong>ddd <\/strong>\u00a0to display the week day in its three letter version or <strong>dddd<\/strong> to display the week day in full.\u00a0<a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/weekday2.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-438\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/weekday2.png\" alt=\"\" width=\"576\" height=\"349\" \/><\/a>\u00a0<a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/weekday3.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-439\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/10\/weekday3.png\" alt=\"\" width=\"578\" height=\"369\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can display the weekday for dates stored in Excel.\u00a0 This is especially useful for checking if due dates fall during the working week.\u00a0 To do this you need to use the weekday function and custom formatting features of Excel.\u00a0 The screenshot below are from Excel 2010, but this work in earlier versions too. Ensure [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[133,148,171,482,588],"class_list":["post-1793","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-custom-format","tag-dates","tag-excel","tag-sf","tag-weekday"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1793","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1793"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1793\/revisions"}],"predecessor-version":[{"id":6763,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1793\/revisions\/6763"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}