You can return a date in a particular format by using the TEXT function.
A1=TODAY() = Monday 01 December 20252=NOW() = Monday 01 December 2025 15:35:093=TEXT(A1, "dd/mm/yy") = 01/12/254=TEXT(A1, "mm/dd/yy") = 12/01/255=TEXT(A1, "dd mmmm, yyyy") = 01 December, 20256=TEXT(A1, "dd-mmm yyyy") = 01-Dec 20257=TEXT(TODAY(), "dd/mmm, yyyy") = 01/Dec, 20258=TEXT("01/07/2020", "dddd mmm yy") = Wednesday Jul 201 - 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 FunctionsNOW - 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 FormulasReturn the date from a date and timeReturn the date of the Monday in the current weekReturn the number corresponding to a given month
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top