Return a date in US date format


 A
1=TODAY() = 02/12/2019
2=NOW() = 02/12/2019
3=TEXT(A1,"mm/dd/yyyy") = 12/02/2019

Built-in Functions

NOW - The serial number of the current system date and time.
TODAY - The serial number representing today's date.
TEXT - The number as a formatted text string.


Related Formulas

Convert a date string to a date value


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