How to Use TODAY Function in Excel

In this article, we will learn about how to use the TODAY function in Excel to get Today’s Date or the current date.
TODAY function is a built-in function to get Today’s Date or Current Date
Syntax:

=TODAY()

NOW function is a built-in function to get current Date and Time in one cell.
Syntax:

=NOW()

Shortcut key to perform the function is Ctrl + Shift + ; (semi-colon)
Here are some snapshots to see how it works
Today function
148
NOW function
149
NOW & TODAY function to get the Current Time
150
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 hortcut key to get current time is Ctrl + Shift + ; (semi-colon)
151
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.

Hope you understood how to use TODAY and NOW function to get current time and Date in Excel. Explore more articles on Statistical Excel function here. Please feel free to state your query or feedback for the above article.

Related Articles:

Excel TIME function

How to use the NOW Function in Excel

How to use WEEKDAY Function in Excel

How to use the MONTH Function in Excel

How to Use the YEAR Function in Excel

Popular Articles:

The VLOOKUP Function in Excel

COUNTIF in Excel 2016

How to Use SUMIF Function in Excel

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube