Return a date in a particular format
|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|
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.
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