{"id":4156,"date":"2020-12-07T15:00:51","date_gmt":"2020-12-07T14:00:51","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=4156"},"modified":"2020-12-07T15:00:51","modified_gmt":"2020-12-07T14:00:51","slug":"formula-de-hoje-no-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-formulas\/today-formula-google-sheets\/","title":{"rendered":"Como usar a fun\u00e7\u00e3o TODAY no Planilhas Google"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ global_colors_info=”{}” theme_builder_area=”post_content”]

The Google Sheets TODAY function returns the current date and time, based on the user\u2019s computer settings. It\u2019s a dynamic or \u201cvolatile\u201d Google Sheets function, meaning that it recalculates automatically.<\/span><\/p>\n

The TODAY function is a useful way to keep dates in your spreadsheet current, regardless of when you first entered the date in your spreadsheet. It can also be combined with multiple other functions.<\/span><\/p>\n

Syntax<\/h2>\n

Unlike most other functions that Google Sheets offers, this one doesn\u2019t take in any input parameters. Trying to add them will result in an error.<\/span><\/p>[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ border_width_left=”4px” global_colors_info=”{}” theme_builder_area=”post_content”]

=TODAY()<\/p>[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

How to use the TODAY function in Google Sheets<\/h3>\n

This is one of the most straightforward functions available within Google Sheets.<\/span><\/p>\n

You can use it as a standalone function, or you can make this an input parameter to other existing functions as shown in the image below.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/TODAY-function-in-Google-Sheets-1.png” alt=”TODAY function in Google Sheets 1″ title_text=”TODAY function in Google Sheets 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ global_colors_info=”{}” theme_builder_area=”post_content”]

The first few examples show the TODAY function in its most basic form. By typing =TODAY() into a cell, you can get today\u2019s date.<\/span><\/p>\n

For Google Sheets the unit of measure is days, meaning there is a direct correlation between days and whole numbers. This is a little abstract, but the important thing to understand is that you can make google sheets add days to date.<\/span><\/p>\n

For example, to find out what is 365 days from today, you would simply add 365 to TODAY.<\/span><\/p>[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

=TODAY()+365<\/span><\/p>[\/et_pb_text][et_pb_text admin_label=”Connections T – Automate data transfers – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#003999″ max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” global_module=”50468″ saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”]

\"\"<\/p>\n

\"39\"<\/p>\n

Automate data transfers beyond Importrange<\/span><\/p>\n

Find out how<\/a><\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ global_colors_info=”{}” theme_builder_area=”post_content”]

Combining TODAY with other functions<\/h4>\n

TODAY is pretty versatile and you can combine it with a few other functions to get different results. This is shown in the examples below.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/TODAY-function-in-Google-Sheets-2.png” alt=”TODAY function in Google Sheets 2″ title_text=”TODAY function in Google Sheets 2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.<\/p>[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

=EOMONTH(TODAY(),1)<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

EOMONTH stands for \u201cend of the month\u201d. This function returns the date of the last day in a month given a starting date and a month offset.<\/span><\/p>\n

In simpler terms, the formula above returns the date of the end of next month. If this was used in January 2024, the formula would return the date \u201c02\/28\/2024\u201d.<\/span><\/p>\n

I\u2019m using the TODAY function as the reference date, and the 1 instructs the function to offset the resulting month by 1.<\/span><\/p>\n

EDATE<\/h4>\n

Another good use of TODAY is within the EDATE function. This is similar to the previous function, but it gives you a date that is a specified number of months before or after a date.<\/span><\/p>[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

=EDATE(TODAY(),-11)<\/strong>\u00a0<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

The example above tells the function to return the date 11 months prior to today.<\/span><\/p>\n

Working days<\/span><\/h4>\n

The last function we will cover is NETWORKDAYS which gives you the net number of working days between two dates.<\/span><\/p>[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

=NETWORKDAYS(TODAY(), TODAY() + 31)<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

The dates in the example are generated using the TODAY function \u2013 today\u2019s date, and the date 31 days from today.<\/span><\/p>\n

The function tells me that there are 22 workdays (i.e. weekdays, with no weekends) between the two dates. This can be very useful for business planning purposes where weekends are generally not counted.<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

TODAY function vs. NOW function<\/h3>\n

The TODAY function is great if you want to generate today\u2019s date. But what if your spreadsheet also needs to include the time?<\/span><\/p>\n

You can <\/span>get the current date and time in Google Sheets with the NOW function<\/b>.<\/span><\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/TODAY-function-in-Google-Sheets-3.png” alt=”TODAY function in Google Sheets 3″ title_text=”TODAY function in Google Sheets 3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

This function lets you generate the current date and time, right to the second. The NOW function can be used as a more precise substitute for the TODAY function in all of the examples shown above.<\/span><\/p>[\/et_pb_text][et_pb_text admin_label=”Connections T – Automate beyond importrange – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container” _builder_version=”4.27.2″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” saved_tabs=”all” global_colors_info=”{}” global_module=”50462″ theme_builder_area=”post_content”]\"\"\n\n\"39\"\n\nAutomate data transfers beyond Importrange<\/span>\n\nFind out how<\/a>[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

TODAY function: Key tips<\/h3>\n

The TODAY function can be very handy when you use Google Sheets to store time-critical information.<\/span><\/p>\n

As already mentioned, if the TODAY function displays 24-Oct-2020 now and you open the file one day from now, the function will show 25-Oct-2020.<\/span><\/p>\n

Although this is the intended functionality of TODAY, there are two problems with this behavior:<\/span><\/p>\n

    \n
  1. You don\u2019t want a \u201crunning\u201d date<\/b>: If you want to insert the current date in a cell but don\u2019t want it to change, there is a shortcut for that, just press Ctrl + ; (semicolon) [Command + ; (semicolon) for Mac]. If this doesn\u2019t work, it\u2019s probably your keyboard configuration, hold down Ctrl and then button mash until you find it.<\/span><\/li>\n
  2. Poor Google Sheets performance<\/b>: Multiple TODAY functions within a spreadsheet may cause performance issues. Since this function is time-sensitive, Google Sheets recalculates the TODAY function very frequently and this results in an increased load.<\/span><\/li>\n<\/ol>\n

    Looking for more help using dates in Google Sheets?<\/h4>\n

    Check out our other spreadsheet tutorials below or read how to use the YEAR function<\/a>\u00a0or how to calculate differences between dates<\/a> in Google Sheets.<\/p>[\/et_pb_text][et_pb_text _builder_version=”4.22.2″ background_color=”#f9f9ff” custom_margin=”40px||40px||false|false” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ global_module=”26540″ saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”]

    Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"

    The Google Sheets TODAY function returns the current date and time, based on the user\u2019s computer settings. It\u2019s a dynamic or \u201cvolatile\u201d Google Sheets function, meaning that it recalculates automatically. The TODAY function is a useful way to keep dates in your spreadsheet current, regardless of when you first entered the date in your spreadsheet. […]<\/p>\n","protected":false},"author":40,"featured_media":27671,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"In Google Sheets, the TODAY<\/a> formula returns the current date, as per the local date and time settings on the user's computer. For example, if a user from Australia used the TODAY formula at 6:00 AM AEST, and the output it returned is 25-Apr-2017. Then, a different user located in the United States of America using it at the exact same time will see the output as 24-Apr-2017.\n

    Syntax<\/h3>\nTODAY()<\/strong><\/span>\n\nNote: Unlike many other formulas that Google Sheets comes with, this one doesn't take in any input parameters. Trying to do so will certainly result in an error.\n

    Usage: Today Formula<\/h3>\nThis is one of the simplest and straightforward formulas available within Google Sheets. We can use this as a standalone formula, or we can me this an input parameter to other existing formulas as shown in the snapshot below.\n\n\"TODAY\n\nThe TODAY formula can get very handy when we use Google Sheets to hold our time critical information. However, it is very important to understand that the formula will always represent the current date (from the last time the spreadsheet calculated formulas). And, it does not remain at the date it displayed when we first used it. So, for example, if the TODAY formula shows 24-Apr-2017 now. And if we open the file one day from now, the formula will show 25-Apr-2017. While that is how we expect it to work, there are two problems with this behavior.\n
      \n \t
    1. This 'running' date may not be a desirable functionality for many users.\n