Home  »  Excel   »   Getting current Date and Time in Excel 2010/2013/2016

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

By | December 2, 2017

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.