Return a date in a particular format

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


Cell "A1" displays the current date. Custom format "dddd dd mmmm yyyy".
Cell "A2" displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
Cell "A3" displays the current date in the format "dd/mm/yy".
Cell "A4" displays the current date in the format "mm/dd/yy".
Cell "A5" displays the date from cell "A2" in the format "dd mmmm, yyyy".
Cell "A6" displays the date from cell "A2" in the format "dd-mmm yyyy".
Cell "A7" displays the current date in the format "dd/mmm, yyyy".
Cell "A8" displays the date "01/07/2020" in the format "dddd mmm yy".

 A
1=TODAY() = Sunday 01 May 2022
2=NOW() = Sunday 01 May 2022 18:37:54
3=TEXT(A1,"dd/mm/yy") = 01/05/22
4=TEXT(A1,"mm/dd/yy") = 05/01/22
5=TEXT(A1,"dd mmmm, yyyy") = 01 May, 2022
6=TEXT(A1,"dd-mmm yyyy") = 01-May 2022
7=TEXT(TODAY(),"dd/mmm, yyyy") = 01/May, 2022
8=TEXT("01/07/2020","dddd mmm yy") = Wednesday Jul 20

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


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