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 takes no parameters but requires empty parentheses.

Example of NOW Function in Excel:

Formula:

Result:

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:

Result:

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