In this post you will learn how to get the current date and time in Excel.
Getting the current date and time –
Instead of typing the current date and time, you can use one of two Excel functions. The
TODAY function returns the current date:
=TODAY()The NOW() function returns the current date along with the current time:
=NOW()Both the TODAY and NOW functions return date serial numbers that represent the current
system date and time. The TODAY function assumes 12 PM as the time, while the NOW func-
tion returns the actual time.
It’s important to note that both of these functions will automatically recalculate each time
you change or open your workbook, so don’t use these functions as a timestamp of record.