Return a date in a particular format

You can return a date in a particular format by using the TEXT function.


 A
1=TODAY() = Sunday 19 May 2024
2=NOW() = Sunday 19 May 2024 13:52:44
3=TEXT(A1, "dd/mm/yy") = 19/05/24
4=TEXT(A1, "mm/dd/yy") = 05/19/24
5=TEXT(A1, "dd mmmm, yyyy") = 19 May, 2024
6=TEXT(A1, "dd-mmm yyyy") = 19-May 2024
7=TEXT(TODAY(), "dd/mmm, yyyy") = 19/May, 2024
8=TEXT("01/07/2020", "dddd mmm yy") = Wednesday Jul 20

1 - Displays the current date. Custom format "dddd dd mmmm yyyy".
2 - Displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
3 - Displays the current date in the format "dd/mm/yy".
4 - Displays the current date in the format "mm/dd/yy".
5 - Displays the date from cell "A2" in the format "dd mmmm, yyyy".
6 - Displays the date from cell "A2" in the format "dd-mmm yyyy".
7 - Displays the current date in the format "dd/mmm, yyyy".
8 - Displays the date "01/07/2020" in the format "dddd mmm yy".


Built-in Functions

NOW - The date serial number of the current system date and time.
TODAY - The date 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


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