{"id":63,"date":"2016-03-01T04:26:33","date_gmt":"2016-03-01T04:26:33","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=63"},"modified":"2024-11-14T16:31:31","modified_gmt":"2024-11-14T05:31:31","slug":"today-function-excel","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel","title":{"rendered":"The TODAY Function in Excel"},"content":{"rendered":"\n

Excel converts dates into sequential numbers beginning from January 1, 1900, you will be able to use a range of special functions dedicated to dates. The TODAY<\/strong><\/em> function returns the sequential numbers for today\u2019s date and will update accordingly if the workbook is opened on another day. Get excited!
The general function to find out the sequential number<\/strong> for today\u2019s date is =TODAY()<\/strong><\/em>.
It is also handy to know that the sequential number for TODAY<\/strong><\/em> changes every day, so your worksheet will show updated results each time you open it.
Before you start, ensure that the data you are working with in your Excel worksheet looks similar to what is present in the screen capture in Step 1<\/strong><\/em>.<\/p>\n\n\n\n\n\n\n\n

TODAY Function: How-to<\/h2>\n\n\n\n

STEP 1<\/span><\/strong><\/span>:<\/p>\n\n\n\n

Select cell F6<\/strong>, then type in =(TODAY()-E6)\/365.25<\/strong>.<\/p>\n\n\n\n

In this formula (=(TODAY()-E6)\/365.25)<\/strong> we are taking the sequential number for the birth date away from the sequential number for TODAY. This will tell us how many days the person has been alive. Dividing by 365.25 (the .25 allows for leap years, will calculate the years.<\/em>
Once you have entered in the formula, press ENTER<\/span> to display the result.<\/p>\n\n\n\n

\n
\"Microsoft<\/figure>\n<\/div>\n\n\n


STEP 2<\/span><\/strong><\/span>:<\/p>\n<\/div><\/div>\n\n\n\n

Then select cell F6<\/strong> again, click on the HOME<\/strong><\/em> tab, then click on Comma Style<\/em><\/strong> in the Number group and click on Decrease Decimal until only a whole number appears.<\/p>\n\n\n\n

\n
\"Microsoft<\/figure>\n<\/div><\/div><\/div>\n\n\n\n

STEP 3<\/span><\/strong><\/span>:<\/p>\n\n\n\n

Following on, double-click on the fill handle to copy the formula down from cell F6<\/strong> to F14<\/strong>.
\u00ad\u00ad<\/p>\n\n\n\n

\n
\"Microsoft<\/figure>\n<\/div><\/div><\/div>\n\n\n\n

STEP 4<\/span><\/strong><\/span>:<\/p>\n\n\n\n

Click in cell H6<\/strong>, type in =(TODAY()-G6)\/365.25<\/strong> then press CTRL+ ENTER<\/span> to enter the formula and stay in the cell. Now repeat Step 3<\/em> until a whole number (only) appears in cell H6<\/strong>.<\/p>\n\n\n\n

\n
\n
\n
\"Microsoft<\/figure>\n<\/div><\/div><\/div>\n<\/div><\/div>\n<\/div><\/div>\n\n\n\n

STEP 5<\/span><\/strong>:<\/p>\n\n\n\n

Double-click on the fill handle to copy the formula down from cell H6<\/strong> to cell H14<\/strong>.<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Excel converts dates into sequential numbers beginning from January 1, 1900, you will be able to use a range of special functions dedicated to dates. The TODAY function returns the sequential numbers for today\u2019s date and will update accordingly if the workbook is opened on another day. Get excited!The general function to find out the…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-63","post","type-post","status-publish","format-standard","hentry","category-microsoft-excel"],"yoast_head":"The TODAY Function in Excel - Dynamic Web Training Blog<\/title>\n<meta name=\"description\" content=\"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The TODAY Function in Excel - Dynamic Web Training Blog\" \/>\n<meta property=\"og:description\" content=\"TODAY function in Excel returns the sequential numbers for today\u2019s date and will update accordingly if the workbook is opened on another day.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel\" \/>\n<meta property=\"og:site_name\" content=\"Dynamic Web Training Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-01T04:26:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-14T05:31:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelTodayFunction-1-DynamicWebTraining.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png\",\"width\":361,\"height\":109,\"caption\":\"Dynamic Web Training\"},\"image\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/\",\"name\":\"Dynamic Web Training Blog\",\"description\":\"The Ultimate Training Experience.\",\"publisher\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelTodayFunction-1-DynamicWebTraining.jpg\",\"width\":827,\"height\":383},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel#webpage\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel\",\"name\":\"The TODAY Function in Excel - Dynamic Web Training Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel#primaryimage\"},\"datePublished\":\"2016-03-01T04:26:33+00:00\",\"dateModified\":\"2024-11-14T05:31:31+00:00\",\"description\":\"TODAY function in Excel returns the sequential numbers for today\\u2019s date and will update accordingly if the workbook is opened on another day.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"name\":\"Training Blog\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\",\"name\":\"Training\"}},{\"@type\":\"ListItem\",\"position\":3,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel\",\"name\":\"Microsoft Excel\"}},{\"@type\":\"ListItem\",\"position\":4,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel\",\"name\":\"The TODAY Function in Excel\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel#webpage\"},\"author\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\"},\"headline\":\"The TODAY Function in Excel\",\"datePublished\":\"2016-03-01T04:26:33+00:00\",\"dateModified\":\"2024-11-14T05:31:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel#webpage\"},\"publisher\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/today-function-excel#primaryimage\"},\"articleSection\":\"Microsoft Excel\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"caption\":\"Dynamic Web Training\"},\"description\":\"Dynamic Web Training is Australia's leading provider of instructor led software training. We offer training courses in Adobe, Web Design, Graphic Design, Photoshop, InDesign, Dreamweaver and many more.\",\"sameAs\":[\"https:\/\/www.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"]}]}<\/script>","_links":{"self":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/63","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/comments?post=63"}],"version-history":[{"count":17,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/63\/revisions"}],"predecessor-version":[{"id":2008,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/63\/revisions\/2008"}],"wp:attachment":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=63"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=63"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=63"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}