Question

Which function displays the current date?
​

Answer 1

Answer:

If you need to display the current date and time, use the NOW function. The Excel TODAY function returns the current date, updated continuously when a worksheet is changed or opened. The TODAY function takes no arguments. You can format the value returned by TODAY using any standard date format.