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 is a Volatile function 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() = 45597.0000
2	=NOW() = 45597.5297
3	=TODAY() = Friday, November 01, 2024
4	=NOW() = Friday, November 01, 2024, 12:42
5	=NOW()-1 = Thursday, October 31, 2024, 12:42
6	=NOW()+1 = Saturday, November 02, 2024, 12:42
7	=DAY(NOW()) = 1
8	=MONTH(NOW()) = 11
9	=YEAR(NOW()) = 2024
10	=HOUR(NOW()) = 12
11	=MINUTE(NOW()) = 42
12	=SECOND(NOW()) = 50

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.