How to Use Excel NOW Function (Examples + Video)

Excel NOW Function (Example + Video)


When to use Excel NOW Function

NOW function can be used to get the current date and time value. It is useful when you want to update the time whenever someone opens a worksheet or when a calculation is dependent on current time.

What it Returns

It returns a serial number that represents the current date and time. The integer part of the serial number represents the date and decimal portion represents time.



Input Arguments

  • NOW function does not take any input arguments. It is used with empty parenthesis.
Additional Notes
  • NOW is a volatile function and should be used with caution.
    • It recalculates whenever the excel workbook is open or whenever a calculation is triggered in the worksheet. This means that the value of NOW keeps on changing based on the current date and time.
    • It can be forced to recalculate by pressing the F9 key. This recalculates the entire workbook calculations.
    • To get static time (that does not recalculate), either manually type the value or use the keyboard shortcut Control + Shift + : (Note: this shortcut gets the time component only, and not the date).
  • If you do not want the Excel NOW function to recalculate, again and again, you can change the calculations settings from automatic to manual. You can find this setting in the Excel Options.

Excel NOW Function – Live Examples

Excel NOW Function – Video Tutorial

Related Excel Functions:

You May Also Like the Following Excel Tutorials:

  • Shrikant Saxena says:

    Each time, I get to learn something new from your posts. I already knew about =Now() but didn’t know that I can use it in addition(=Now() +A2, also that I can tailor it to show AM/PM. Keep up the good work man!

  • >