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:
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