Now Function

In this article, I will discuss about a very tiny but very powerful function in the category Date/Time Function and it is NOW Function.

Although it is a very small function in Microsoft Excel but you can list this function in your time saving function lists.
So, let’s see how to use this useful function.

Description
The Microsoft Excel NOW function returns the current system date and time.

The NOW function will refresh the date/time value whenever the worksheet recalculates which means it will refresh the date & time wherever you type something in the excel sheet. 

Note : To stop this feature of NOW Function go to Formula menu, at the end you will find Calculation tab, click on Calculation Option, select Manual from Automatic. This will prevent entire Excel from refreshing or Calculating, therefore you other formula may not work, so after you are done don’t FORGET to switch this option from Manual to Automatic.

Calculation Option

The spreadsheet will continue to display this value, until the worksheet recalculates. By pressing the F9 key, you can force the worksheet to recalculate and the NOW function will update its value.

Syntax

The syntax for the NOW function in Microsoft Excel is as under.

=NOW()

Parameters or Arguments

There are no parameters or arguments for the NOW function.

Returns

The NOW function returns a date & value.

Example :

How to use Now Function

Hope you have enjoyed this article...
Thank you for reading...