{"id":1099,"date":"2012-11-08T11:01:06","date_gmt":"2012-11-08T11:01:06","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1099"},"modified":"2023-12-30T23:11:50","modified_gmt":"2023-12-30T23:11:50","slug":"formatting-dates-in-excel-to-get-the-results-you-need","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/formatting-dates-in-excel-to-get-the-results-you-need\/","title":{"rendered":"Formatting dates in Excel to get the results you need"},"content":{"rendered":"<p>Dates are key pieces of information in Excel spreadsheets used for everything from planning, assessing progress and analysing results.<\/p>\n<p>Sometimes you may find that when you use dates in formulas, or as part of sorting or filtering data, the results don&#8217;t come out in the way you&#8217;d expect. \u00a0This can be frustrating and slow down your work. \u00a0Why does Excel do this?<\/p>\n<blockquote><p>When you are working with dates in Excel, it will show you dates and times in the familiar format, but it will store them, and make calculations with them as numbers.<strong>\u00a0\u00a0<\/strong><strong>\u00a0<\/strong><\/p><\/blockquote>\n<p>The tip is to <strong>remember to tell Excel that you want it to work with dates<\/strong>, and not just numbers. \u00a0You can do this by formatting the cell, column or row to use dates.<\/p>\n<p><strong>The format of dates in<\/strong> <strong>Excel<\/strong><strong><br \/>\n<\/strong>Try this<strong>&#8230;.<\/strong>right click in a cell, you can select the date format &#8211; and here is where you can see the <strong>range of ways of expressing dates in Excel<\/strong>. \u00a0Formatting is key to making sure that your dates show in the way you want them to and Excel knows how to use them. \u00a0Choose the one that suits your needs.<\/p>\n<figure id=\"attachment_1106\" aria-describedby=\"caption-attachment-1106\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/Date-format-cells-excell-training-courses.png\"><img decoding=\"async\" class=\"size-medium wp-image-1106\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/Date-format-cells-excell-training-courses-300x264.png\" alt=\"Date-format-cells-excell-training courses\" width=\"300\" height=\"264\" \/><\/a><figcaption id=\"caption-attachment-1106\" class=\"wp-caption-text\">Who knew there were so many ways of showing a date&#8230;.<\/figcaption><\/figure>\n<p><strong>Tip list for working with dates\u00a0<\/strong><\/p>\n<ol>\n<li>Use a consistent date format throughout your worksheets &#8211; it makes it easier to work with and view patterns and trends.<\/li>\n<li>Format the cell, column or row with the date format you need.<\/li>\n<li>You can use format painter to copy the format within the document.<\/li>\n<\/ol>\n<p>Working with date formats is part of our excell computer training courses. \u00a0Take a look at \u00a0<a title=\"Excel Introduction 2007\" href=\"https:\/\/www.stl-training.co.uk\/excel-2007-introduction.php\">https:\/\/www.stl-training.co.uk\/excel-2007-introduction.php<\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dates are key pieces of information in Excel spreadsheets used for everything from planning, assessing progress and analysing results. Sometimes you may find that when you use dates in formulas, or as part of sorting or filtering data, the results don&#8217;t come out in the way you&#8217;d expect. \u00a0This can be frustrating and slow down [&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":[241],"class_list":["post-1099","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-excell-computer-training"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1099","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=1099"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1099\/revisions"}],"predecessor-version":[{"id":6716,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1099\/revisions\/6716"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1099"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1099"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1099"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}