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.
Click to enlarge Usage example with TEXT function
="Today is "&TEXT(TODAY(),"mmmm d, yyyy")
Click to enlarge -
=NOW()
-
Returns the current date along with the current time. Returns the actual time.
Click to enlarge Usage example with TEXT function
="Now is "&TEXT(NOW(), "hh:mm:ss")
Click to enlarge
