Return a date in a particular format


 A
1=TODAY() = 02/12/2019
2=NOW() = 02/12/2019
3=TEXT(A1,"dd mmmm, yyyy") = 02 December, 2019
4=TEXT(A1,"dd-mmm yyyy") = 02-Dec 2019
5=TEXT(TODAY(),"dd mmmm, yyyy") = 02 December, 2019
6=TEXT("01/07/2020","dd mmmm, yyyy") = 01 July, 2020

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

Return the date from a date and time
Return the date of the Monday in the current week
Return the number corresponding to a given month


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