How to use the TODAY function in Excel

In this article, we will learn How to use the TODAY function in Excel.

Today's date value in Excel

In Excel, If you need to use today's date without any trouble, you just need to use this function. For Example working with attendees for the employee. You cannot afford to have human error while doing so. Let's learn how to use the easiest function in Excel. Today function syntax and is explained using an example

TODAY Function in Excel

TODAY function doesn't take any input. It fetches current results from the system. TODAY function extracts the date of the current day in the date format.

Syntax:

Example :

All of these might be confusing to understand. Let's understand how to use the function using an example. Here i will show you some results using the Excel today function. Learn using some snapshots to see how it works

Today function

NOW function is the advanced version of date and time function. It lets you know how to get the date and time both in the same cell.

NOW & TODAY function to get the Current Time

Shortcut keys to perform the same function as above

In the B1 cell use Shortcut key to get current date is Ctrl + ; (semi-colon)

In the B2 cell use shortcut key to get current time is Ctrl + Shift + ; (semi-colon)

In the B3 cell use Ctrl + ; (semi-colon) and After single space use Ctrl +Shift + ; (semi-colon) to get both date & time in the same cell.

Here are all the observational notes using the TODAY function in Excel
Notes :

1. The TODAY function used in Excel gets updated everyday. Copy and paste value in another cell to use that date.
2. NOW function gets updated every time you ask your sheet to update function results

Hope this article about How to use the TODAY function in Excel is explanatory. Find more articles on calculating values and related Excel formulas here. If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write to us at info@exceltip.com.

Related Articles :

Convert Date and Time from GMT to CST : While working on Excel reports and Excel dashboards in Microsoft Excel, we need to convert Date and Time. In addition, we need to get the difference in timings in Microsoft Excel. 

How to Convert Time to Decimal in Excel : We need to convert the time figures into decimals using a spreadsheet in Excel 2016. We can manipulate time in excel 2010, 2013 and 2016 using the function CONVERT, HOUR and MINUTE.

How to Convert date to text in Excel : In this article we learned how to convert text into date, but how do you convert an excel date into text. To convert an excel date into text we have a few techniques.

Converting Month Name to a Number in Microsoft Excel : When it comes to reports numbers are better than text. In Excel if you want to convert month names into numbers (1-12). Using the function DATEVALUE and MONTH you can easily convert months into numbers.

Excel converts decimal Seconds into time format : As we know that time in excel is treated as numbers. Hours, Minutes, and Seconds are treated as decimal numbers. So when we have seconds as numbers, how do we convert into time format? This article got it covered.

Popular Articles :

How to use the IF Function in Excel : The IF statement in Excel checks the condition and returns a specific value if the condition is TRUE or returns another specific value if FALSE.

How to use the VLOOKUP Function in Excel : This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets.

How to use the SUMIF Function in Excel : This is another dashboard essential function. This helps you sum up values on specific conditions.

How to use the COUNTIF Function in Excel : Count values with conditions using this amazing function. You don't need to filter your data to count specific values. Countif function is essential to prepare your dashboard.