Convert a date into text in date format:

If you would like to convert a date value into text, but with the date format. We can convert a date into text in a format as per our wish. Like MM/DDD/YYYY or MM-DDD-YYYY or DD-MMM-YY.




In the above example, we have dates in the A column and it was converted into text in a different format using TEXT formula.