articles

Home / DeveloperSection / Articles / NOW Function in Excel

NOW Function in Excel

AVADHESH PATEL3550 28-Mar-2013

The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.

 NOW function return the current date and time of system. If the cell format was General before the function was entered, Excel changes the cell format to the same date and time format that is specified in the regional date and time settings in Control Panel. You can change the date and time format for the cell by using the commands in the Number group of the Home tab on the Ribbon.

Note:  Where you apply NOW function, that column’s data type should be General or Date format. 

Syntax

= NOW ( )

NOW Function in Excel


Updated 07-Sep-2019
Avadhesh Kumar Patel District Project Manager - Aligarh 14 months work experience in Panchayati Raj Department Sector as District Project Manager & 12 months work experience in IT Sector as Software Engineer. :-)

Leave Comment

Comments

Liked By