{"id":1348,"date":"2015-06-11T12:20:03","date_gmt":"2015-06-11T10:20:03","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1348"},"modified":"2024-05-23T21:30:04","modified_gmt":"2024-05-23T19:30:04","slug":"custom-date-formats-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/custom-date-formats-in-excel\/","title":{"rendered":"Custom Date Formats in Excel"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-custom-number-format\/\" target=\"_blank\" rel=\"noopener\">Custom date formats in Excel<\/a> allow you to display only certain parts of the date.<\/p>\n<p>Say you had a date of 18\/02\/1979, which coincides to be my birthday \ud83d\ude42<\/p>\n<p>You can use the Format Cells dialogue box to show only the number 18, the day that corresponds to that date (Sunday), the month as a number on in abbreviated form and the year in two or four digits.<\/p>\n<p>You cam also mix and match to create a custom <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-date-format\/\" target=\"_blank\" rel=\"noopener\">date format<\/a> or even enter a custom text that would show something like: <em>Today is Sunday<\/em><\/p>\n<p>You can download the following workbook which shows you the different formats that you can use and see the tutorial below of how this can be easily achieved.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/SkQMPAc6brQ?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><br \/>\n<span style=\"text-decoration: underline;color: #0000ff\"><a class=\"IRPP_minimalist icon-download\" style=\"color: #0000ff\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Number-Formats-Dates.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download workbook<\/span><span class=\"postTitle px-3\">Number-Formats-Dates.xlsx<\/span><\/a><\/span><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong><\/span> To see how the formatting works, pick any one on the table. Then press\u00a0<strong>CTRL + 1<\/strong> to open the <strong>Format Cells Dialog<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Custom Date Formats in Excel\" class=\"alignnone size-full wp-image-19703\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Custom-Date-Formats-in-Excel-01.jpg\" alt=\"Custom Date Formats in Excel\" width=\"787\" height=\"561\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Custom-Date-Formats-in-Excel-01.jpg 787w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Custom-Date-Formats-in-Excel-01-300x214.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Custom-Date-Formats-in-Excel-01-768x547.jpg 768w\" sizes=\"(max-width: 787px) 100vw, 787px\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2: <\/strong><\/span>Over here you can see the Custom Date Format used, in our example, it&#8217;s <em><strong>mmmm-yyyy<\/strong><\/em> and there is a sample of <em><strong>February-1979<\/strong><\/em> at the top to show you how it looks like.<\/p>\n<p>Try it out for the different formats!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Custom Date Formats in Excel\" class=\"alignnone size-full wp-image-19704\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Custom-Date-Formats-in-Excel-02.jpg\" alt=\"Custom Date Formats in Excel\" width=\"1303\" height=\"565\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Custom-Date-Formats-in-Excel-02.jpg 1303w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Custom-Date-Formats-in-Excel-02-300x130.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Custom-Date-Formats-in-Excel-02-1024x444.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Custom-Date-Formats-in-Excel-02-768x333.jpg 768w\" sizes=\"(max-width: 1303px) 100vw, 1303px\" \/><\/p>\n<p>Here is the list of codes that you can use:<\/p>\n<table style=\"height: 614px\" width=\"709\">\n<tbody>\n<tr>\n<td width=\"130\"><strong>CODE<\/strong><\/td>\n<td width=\"393\"><strong>OUTPUT<\/strong><\/td>\n<td width=\"114\"><strong>DATE\/TIME<\/strong><\/td>\n<td style=\"text-align: center\" width=\"164\"><strong>APPEARS AS<br \/>\n<\/strong><\/td>\n<\/tr>\n<tr>\n<td>m<\/td>\n<td>Displays the month as a number<\/td>\n<td>18\/02\/1979<\/td>\n<td style=\"text-align: center\">2<\/td>\n<\/tr>\n<tr>\n<td>mm<\/td>\n<td>Displays the month as a number with leading zeros<\/td>\n<td>18\/02\/1979<\/td>\n<td style=\"text-align: center\">02<\/td>\n<\/tr>\n<tr>\n<td>mmm<\/td>\n<td>Displays the month in abbreviated form<\/td>\n<td>18\/02\/1979<\/td>\n<td style=\"text-align: center\">Feb<\/td>\n<\/tr>\n<tr>\n<td>mmmm<\/td>\n<td>Displays the month in full form<\/td>\n<td>18\/02\/1979<\/td>\n<td style=\"text-align: center\">February<\/td>\n<\/tr>\n<tr>\n<td>mmmmm<\/td>\n<td>Displays the first letter of the month<\/td>\n<td>18\/02\/1979<\/td>\n<td style=\"text-align: center\">F<\/td>\n<\/tr>\n<tr>\n<td>d<\/td>\n<td>Displays the day as a number<\/td>\n<td>18\/02\/1979<\/td>\n<td style=\"text-align: center\">18<\/td>\n<\/tr>\n<tr>\n<td>dd<\/td>\n<td>Displays the day as a number with leading zeros<\/td>\n<td>01\/02\/1979<\/td>\n<td style=\"text-align: center\">01<\/td>\n<\/tr>\n<tr>\n<td>ddd<\/td>\n<td>Displays the day in abbreviated form<\/td>\n<td>18\/02\/1979<\/td>\n<td style=\"text-align: center\">Thu<\/td>\n<\/tr>\n<tr>\n<td>dddd<\/td>\n<td>Displays the day in full form<\/td>\n<td>18\/02\/1979<\/td>\n<td style=\"text-align: center\">Thursday<\/td>\n<\/tr>\n<tr>\n<td>yy<\/td>\n<td>Displays the last two digits of the year<\/td>\n<td>18\/02\/1979<\/td>\n<td style=\"text-align: center\">79<\/td>\n<\/tr>\n<tr>\n<td>yyyy<\/td>\n<td>Displays all the digits of the year<\/td>\n<td>18\/02\/1979<\/td>\n<td style=\"text-align: center\">1979<\/td>\n<\/tr>\n<tr>\n<td>mmmm d, yyyy<\/td>\n<td>Displays the month, the date and the year<\/td>\n<td>18\/02\/1979<\/td>\n<td style=\"text-align: center\">February 18, 1979<\/td>\n<\/tr>\n<tr>\n<td>mmmm-yyyy<\/td>\n<td>Displays the month-year<\/td>\n<td>18\/02\/1979<\/td>\n<td style=\"text-align: center\">February-1979<\/td>\n<\/tr>\n<tr>\n<td>&#8220;Today is&#8221; dddd<\/td>\n<td>Displays a custom text for the Today function<\/td>\n<td>11\/06\/2015<\/td>\n<td style=\"text-align: center\">Today is Thursday<\/td>\n<\/tr>\n<tr>\n<td>h<\/td>\n<td>Displays the hour as a number<\/td>\n<td>9:55:13<\/td>\n<td style=\"text-align: center\">9<\/td>\n<\/tr>\n<tr>\n<td>hh<\/td>\n<td>Displays the hour as a number with leading zeros<\/td>\n<td>9:55:13<\/td>\n<td style=\"text-align: center\">09<\/td>\n<\/tr>\n<tr>\n<td>AM\/PM<\/td>\n<td>Displays the hour indicating AM or PM<\/td>\n<td>9:55:13<\/td>\n<td style=\"text-align: center\">AM<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"text-decoration: underline\"><span style=\"color: #0000ff;text-decoration: underline\">HELPFUL RESOURCE:<\/span><\/span><\/p>\n<p><strong>Make sure to download our FREE PDF on the<a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer\"> 333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14329 size-medium\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg\" alt=\"\" width=\"300\" height=\"200\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-1024x682.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-768x512.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups.jpg 1340w\" sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Custom date formats in Excel allow you to display only certain parts of the date. Say you had a date of 18\/02\/1979, which coincides to be my birthday \ud83d\ude42 You can use the Format Cells dialogue box to show only the number 18, the day that corresponds to that date (Sunday), the month as a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":18083,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Custom Date Formats in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,41],"tags":[88,81],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1348"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1348"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1348\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/18083"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}