Return a date in a particular format


 A
1=TODAY() = Wednesday 15 July 2020
2=NOW() = Wednesday 15 July 2020 14:28:08
3=TEXT(A1,"dd mmmm, yyyy") = 44027
4=TEXT(A1,"dd-mmm yyyy") = 44027
5=TEXT(TODAY(),"dd mmmm, yyyy") = 44027
6=TEXT("01/07/2020","dd mmmm, yyyy") = 44013

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


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