Format Date and Time - Using TEXT Function

Formatting Date:

Formatting Month:

Example:

Download The Workbook

Formulas:

=TEXT(A2, "dd-mmm")
=TEXT(A3, "d-mmm-yy")
=TEXT(A4, "dd-mm-yyyy")
=TEXT(A5, "ddd,dd-mm-yyyy")
=TEXT(A6, "dddd,dd-mm-yyyy")
=TEXT(A7, "dddd,dd-mm-mmm-yyyy")
=TEXT(A8, "dddd,dd-mm-mmmm-yyyy")
=TEXT(A9, "dddd,dd-mm-mmmm-yy")