Introduction to NOW Function
NOW function returns the current date and time as per the system’s date and time. The date and time returned by the NOW function update continuously whenever you update anything in the worksheet.
Download Sample File
Download SAMPLE FILE to work, practice and master the TIME Functions in Excel.
Syntax of NOW Function
NOW()
Arguments of NOW Function
In NOW, there is no argument to specify, but you need to take care that this function is a volatile function which changes its value every time you update your worksheet’s calculation.
Example of NOW Function in MS Excel
Below we have used NOW in two different ways:
- In the first example, we have used TEXT Function along with now to extract current time from it.
- In the second example, we have changed the format of the cell to “General”. The number before the decimal point is the current date & number after the decimal point is the time.
Other Excel Time Functions Tutorials
You can explore and master other Time functions in Microsoft Excel. Here is a complete list of Time functions available in Microsoft Excel.
