Return the current date


 A
1=TODAY() = Tuesday 01 October 2024
2=NOW() = Tuesday 01 October 2024 06:08:01

Built-in Functions

NOW - The date serial number of the current system date and time.
TODAY - The date serial number representing today's date.


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.


Related Formulas

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


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