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.