Return a date in a particular format
|1||=TODAY() = 02/01/2020|
|2||=NOW() = 02/01/2020|
|3||=TEXT(A1,"dd mmmm, yyyy") = 02 January, 2020|
|4||=TEXT(A1,"dd-mmm yyyy") = 02-Jan 2020|
|5||=TEXT(TODAY(),"dd mmmm, yyyy") = 02 January, 2020|
|6||=TEXT("01/07/2020","dd mmmm, yyyy") = 01 July, 2020|
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