# NOW

NOW()

Returns the date serial number of the current system date and time.

 REMARKS
 * This is one of few functions that does not require any arguments.* This function is Volatile and will change everytime a cell on the worksheet is calculated.* This function will update when the workbook is recalculated.* You must include the empty parentheses after the function name.* The serial number is the date-time code used by Excel for date and time calculations.* If the cell has the "General" number format, then this cell is formatted automatically to "dd/mm/yyyy hh:mm".* If you want to enter a static date that will not change or update, use the shortcut key (Ctrl + ;).* If you want to enter a static time that will not change or update, use the shortcut key (Ctrl + Shift + ;).* You can use the DATE function to return the date serial number given a YEAR, MONTH, DAY.* You can use the DATEVALUE function to return the date serial number given a date in text format.* You can use the TIME function to return the time as a decimal given an HOUR, MINUTE, SECOND.* You can use the TIMEVALUE function to return the time as a decimal given a time in text format.* You can use the TODAY function to return the serial number of the current system date.* The equivalent VBA function is VBA.NOW* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =TODAY() = 45509.0000 2 =NOW() = 45509.4830 3 =TODAY() = Monday, August 05, 2024 4 =NOW() = Monday, August 05, 2024, 11:35 5 =NOW()-1 = Sunday, August 04, 2024, 11:35 6 =NOW()+1 = Tuesday, August 06, 2024, 11:35 7 =DAY(NOW()) = 5 8 =MONTH(NOW()) = 8 9 =YEAR(NOW()) = 2024 10 =HOUR(NOW()) = 11 11 =MINUTE(NOW()) = 35 12 =SECOND(NOW()) = 30

 1 - What is the serial number of the current system date.2 - What is the serial number of the current system date and time.3 - What is the serial number of the current system date. This cell has been formatted with the number format "dddd, mmmm dd, yyyy".4 - What is the serial number of the current system date and time. This cell has been formatted with the number format "dddd, mmmm dd, yyyy, hh:mm".5 - What is the date and time of the current system date and time minus 1 day.6 - What is the date and time of the current system date and time plus 1 day.7 - What is the day component of the current system date and time.8 - What is the month component of the current system date and time.9 - What is the year component of the current system date and time.10 - What is the hour component of the current system date and time.11 - What is the minute component of the current system date and time.12 - What is the second component of the current system date and time.