how to use excel now function
Quick Intro

Excel NOW Function is super useful. You can use NOW Function to insert the current date and time in a cell. It will insert a valid date and time in a cell which will update every time you recalculate your worksheet.

Syntax

NOW()

  • There is no argument in NOW Function. But you have to enter empty parentheses.

More Information on Excel NOW Function

  • NOW is a volatile function and will update every time when a recalculation is done.
  • As it is a volatile function, it can effect on the processing speed of your calculation.
  • It enters a valid serial number of current data & time as per excel’s date & time system.
  • When you enter this function in a cell it will convert the format of the cell into a custom format (m/d/yyyy h:mm).
  • To enter a static current date & time you can use keyboard shortcut key CTRL + SHIFT + : (Current Time) & CTRL + : (Current Date) to enter current date.

Examples

  • In the first example, I have used TEXT Function along with now to extract current time from it.
  • In the second example, I have changed the format of the cell to “General”. The number before decimal is the current date & number after the decimal is the time.

Examples For Excel NOW Function

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel NOW Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have TODAY function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.



  • shrikant

    I tried & succeeded in it. Pl guide about pivot table/slicers & their interlinking as to where to field which values/location etc. thanks
    shrikant

  • Be aware that the date/time shortcuts differ between the languages (e.g. German: CTRL + . for current date, CTRL + SHIFT + . for current time.