{"id":384675,"date":"2021-12-22T23:00:41","date_gmt":"2021-12-22T20:00:41","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-insert-todays-date-in-microsoft-excel\/"},"modified":"2021-12-22T23:00:41","modified_gmt":"2021-12-22T20:00:41","slug":"how-to-insert-todays-date-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-insert-todays-date-in-microsoft-excel\/","title":{"rendered":"#How to Insert Today\u2019s Date in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 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-6a2d830319916\" 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-6a2d830319916\" 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-insert-todays-date-in-microsoft-excel\/#Static_vs_Dynamic_Dates_in_Excel\" >Static vs Dynamic Dates 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-insert-todays-date-in-microsoft-excel\/#Insert_Todays_Date_as_a_Static_Date_in_Excel\" >Insert Today\u2019s Date as a Static Date in Excel<\/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-insert-todays-date-in-microsoft-excel\/#Add_Todays_Date_as_a_Dynamic_Date_in_Excel\" >Add Today\u2019s Date as a Dynamic Date in Excel<\/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-insert-todays-date-in-microsoft-excel\/#Change_the_Date_Format_in_Excel\" >Change the Date Format in Excel<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Insert Today\u2019s 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>Need to stamp a date on a spreadsheet? In Microsoft Excel, you have multiple ways to add today\u2019s date in your spreadsheets. You can add both static and dynamic dates, and we\u2019ll show you how.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Static_vs_Dynamic_Dates_in_Excel\"><\/span>Static vs Dynamic Dates in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you add a <strong>static date<\/strong> in your Excel spreadsheet, the date does not update when you <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/252463\/how-to-manually-calculate-only-the-active-worksheet-in-excel\/\">recalculate your worksheet or you reopen the spreadsheet. It remains the same no matter what you do.<\/p>\n<p>On the other hand, when you add a <strong>dynamic date<\/strong> to your spreadsheet, the date updates when you recalculate your worksheet or you reopen the spreadsheet. This date is added with an Excel function, which is why it\u2019s updated when you perform recalculation.<\/p>\n<p>In either case, Excel fetches the current date from your computer\u2019s system clock, so make sure it\u2019s set to use the correct date.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to See Multiple Time Zone Clocks on Windows 10&#8217;s Taskbar<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Insert_Todays_Date_as_a_Static_Date_in_Excel\"><\/span>Insert Today\u2019s Date as a Static Date in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To insert today\u2019s date as a static value in your spreadsheet, first, open your spreadsheet with Microsoft Excel.<\/p>\n<p>In the spreadsheet, click the cell in which you want to display today\u2019s date.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767138\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/1-select-cell.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a cell to display the date in an Excel spreadsheet.\" width=\"585\" height=\"295\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>While the cell is selected, press Ctrl+; (semicolon) to add today\u2019s date in the cell. This keyboard shortcut works on both Windows and Mac.<\/p>\n<p>Your cell now has today\u2019s date in it.<\/p>\n<blockquote class=\"admonishment_tip\"><p><strong>Tip:<\/strong> To add the current time, press Ctrl+Shift+; on Windows or Command+; on Mac.<\/p><\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767139\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/2-add-today-date-excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Today's date in a cell in Excel.\" width=\"581\" height=\"296\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>That\u2019s it.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Add_Todays_Date_as_a_Dynamic_Date_in_Excel\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">Add Today\u2019s Date as a Dynamic Date in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To add today\u2019s date in such a way that it updates when you recalculate or reopen your spreadsheet, use the Excel formula for today\u2019s date,\u00a0<code>TODAY<\/code>.<\/p>\n<p>To use it, open your spreadsheet with Microsoft Excel. Then click the cell in which you want to display the date.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767138\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/1-select-cell.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a cell to display the date in an Excel spreadsheet.\" width=\"585\" height=\"295\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the cell, type the following function and press Enter:<\/p>\n<pre>=TODAY()<\/pre>\n<blockquote class=\"admonishment_tip\"><p><strong>Tip:<\/strong> To add both the current date and time, use the <code>=NOW()<\/code> formula instead.<\/p><\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767140\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/3-excel-today-function.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter the function to add today's date.\" width=\"587\" height=\"320\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And Excel will display today\u2019s date in your cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767141\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/4-insert-today-date-excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Today's date added with a function in Excel.\" width=\"584\" height=\"296\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you reopen your spreadsheet, you will see the date of that day.<\/p>\n<p><strong>RELATED:<\/strong> <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/252463\/how-to-manually-calculate-only-the-active-worksheet-in-excel\/\"><strong><em>How to Manually Calculate Only the Active Worksheet in Excel<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Change_the_Date_Format_in_Excel\"><\/span>Change the Date Format in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you prefer a specific format for your dates, Excel has an option to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/761403\/how-to-change-date-formats-in-microsoft-excel\/\">customize the date format. This way, you can display your date in whatever format you desire.<\/p>\n<p>To do that for your date, right-click your date cell and select \u201cFormat Cells\u201d from the menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767142\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/5-format-date-cell-excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Right-click the date cell and choose &quot;Format Cells.&quot;\" width=\"650\" height=\"478\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>On the \u201cFormat Cells\u201d window, from the \u201cType\u201d section on the right, select the format you want for your date. Then click \u201cOK\u201d at the bottom.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767143\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/6-change-date-format-excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a date format and click &quot;OK&quot; on the &quot;Format Cells&quot; window.\" 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>Your date now uses your selected format.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767144\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/7-new-date-format-excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Today's date in a different format.\" width=\"588\" height=\"288\" 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 quickly display today\u2019s date in your various spreadsheets. Very useful!<\/p>\n<hr\/>\n<p>Excel has various features with regards to dates, like the ability to sort your data by date\u00a0or calculate age in your spreadsheets.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Sort by Date 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\/767135\/how-to-insert-todays-date-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Insert Today\u2019s Date in Microsoft Excel&#8221; Need to stamp a date on a spreadsheet? In Microsoft Excel, you have multiple ways to add today\u2019s date in your spreadsheets. You can add both static and dynamic dates, and we\u2019ll show you how. Static vs Dynamic Dates in Excel When you add a static date&#8230;<\/p>\n","protected":false},"author":1,"featured_media":384676,"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-384675","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\/384675","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=384675"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/384675\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/384676"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=384675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=384675"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=384675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}