NOW function is used to get the current date and time value provided the cell format is date/date time/time in both excel and Google sheet. It is useful when you want to update the time whenever someone opens a worksheet or when a calculation is dependent on current time.
Input Arguments :
- NOW function doesn’t need any input arguments.
In the example below, in cells A2, B2 & C2 we have used NOW() function. Based on the cell format it returned Date & Time in A2, only Date in B2 and Only Time in C2.
You can get the result of Now() function in any of the formats you have selected for your cell. To choose the cell format in Google Sheet first select the desired cell and then click Format in menu bar. Then navigate to Number and then select the format you need for the cell from the available options as Date/Time/Date Time as follows.
NOW is a volatile function. This means that the value of NOW keeps on changing based on current date and time. In Google Sheet you can specify the Re-Calculation setting for this function with the below process.
- Go to File Menu
- Click Spreadsheet Settings
- Now in the Spreadsheet Settings pane go to Calculation. There you will find the available options to select how often you want the function to re-calculate in this spreadsheet. Select the appropriate one as needed from On Change/On Change and every minute/ On change and every hour.
- Then click Save Settings.