So applying the NOW formula in Excel to other cells we have the output. As a worksheet function the NOW function can be entered as part of a formula in a cell of a worksheet. NOW function is a built-in dynamic function to get current Date and Time in one cell.
Please remember this will only change the display format the actual value stored in a cell will still be a decimal number consisting of an integer representing the date and a fractional part representing the time.
The NOW function takes no arguments. Click on the bottom edge and drag to see other results. Copy the example data in the following table and paste it in cell A1 of a new Excel worksheet. NOW Function in Excel NOW function is a date and time function which returns the current date and time together in a cell in the date time format.