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:


now function in Excel 1


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


now function in Excel 2


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

DataScience Made Simple