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.

=TODAY()

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

excel-today-function
Click to enlarge

Usage example with 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

Usage example with 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.