Return a date in a particular format

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

	A
1	=TODAY() = Monday 01 April 2024
2	=NOW() = Monday 01 April 2024 19:44:48
3	=TEXT(A1, "dd/mm/yy") = 01/04/24
4	=TEXT(A1, "mm/dd/yy") = 04/01/24
5	=TEXT(A1, "dd mmmm, yyyy") = 01 April, 2024
6	=TEXT(A1, "dd-mmm yyyy") = 01-Apr 2024
7	=TEXT(TODAY(), "dd/mmm, yyyy") = 01/Apr, 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