NOW()

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


* 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 DAY function to return the day as an integer given a date serial number.
* You can use the MONTH function to return the month as an integer given a date serial number.
* You can use the YEAR function to return the year as an integer given a date serial number.
* You can use the HOUR function to return the hour as an integer given a date serial number.
* You can use the MINUTE function to return the minute as an integer given a date serial number.
* You can use the SECOND function to return the number of seconds as an integer given a date serial number.
* For the Microsoft documentation refer to support.office.com.

 A
1=NOW() = 8/8/2017 5:43
2=NOW()-1 = 8/7/2017 5:43
3=NOW()+1 = 8/9/2017 5:43
4=DAY(NOW()) = 8
5=MONTH(NOW()) = 8
6=YEAR(NOW()) = 2017
7=HOUR(NOW()) = 5
8=MINUTE(NOW()) = 43
9=SECOND(NOW()) = 49


© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top