Getting Current Date and Time in Excel 2010/2013/2016

0
Please wait...

There are two functions which you can use to get current Date and Time in Excel:

=TODAY()

and

=NOW()

.
You can use these functions as part of a text string by putting them into

TEXT

function with formatting string.

It’s important to note that both of those functions are automatically recalculated each time you change or open your workbook, so don’t use them as a timestamp of record!

You can quickly enter date that does not change by pressing Ctrl + ;
Date will be inserted into the active cell.

=TODAY()

Returns the current date. Assumes 12 p.m. as the time.

excel-today-function
Click to enlarge

Example of using TEXT function

="Today is "&TEXT(TODAY(),"mmmm d, yyyy")

excel-today-text-function
Click to enlarge

=NOW()

Returns the current date along with the current time. Returns the actual time.

excel-now-function
Click to enlarge

Example of using TEXT function

="Now is "&TEXT(NOW(), "hh:mm:ss")
excel-now-text-function
Click to enlarge

Leave A Reply

Your email address will not be published.