Return the current date and time


 A
1=TODAY() = Wednesday 01 June 2022
2=NOW() = Wednesday 01 June 2022 05:41:48

Built-in Functions

NOW - The serial number of the current system date and time.


Shortcut Keys

(Ctrl + ;) - Enters the current date into the active cell and applies the format "dd/mm/yyyy" (Regional Settings). This is static and will not update.
(Ctrl + Shift + ;) - Enters the current time into the active cell. This is static and will not update.


Related Formulas

Return the current date
Return the current day
Return the current month
Return the current time
Return the current year


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top