Which if the following functions will print the date and time on an excel sheet?

Question

DateTime()
Date()
Now()
Hours()

Answer 1

In Excel, the function that will print the current date and time is NOW().

Here’s a brief explanation of each function:

• NOW(): Returns the current date and time.
• DATE(): Used to create a date by specifying year, month, and day, but it does not return the current date and time.
• DATEVALUE(): Converts a date in the form of text to a sequential number that Excel recognizes as a date (not in your list).
• HOUR(): Returns the hour of a time value, but does not return the date and time itself (not in your list).

So, among the provided options, NOW() is the correct choice for printing the current date and time.