NOW Function in Excel – Get Current Date and Time in Excel

NOW Function in Excel returns the current date and time. NOW Function does not take any arguments.

Syntax for NOW Function in Excel:

NOW ()

NOW takes no parameters but requires empty parentheses.

Example of NOW Function in Excel:

Formula:

now function in Excel 1

Result:

now function in Excel 1a

Application of Excel NOW Function as a countdown:

The following example shows use of the NOW function. Difference between date of meeting and NOW is calculated and used as count down

Formula:

now function in Excel 2

Result:

now function in Excel 3

Totally 2.99 days left for meeting.

NOTE: NOW Function is updated continuously when a worksheet is changed or opened

If you want to get current date only without time you can use TODAY Function

previous-small NOW Function in Excel                                                                                                                next_small NOW Function in Excel