date_format_code is the format code based on how you want the converted date to look.date is the date, date serial number, or reference to the cell that you want to convert.Here’s the syntax for the TEXT function: = TEXT (date, date_format_code) It takes a date serial number or date and lets you extract parts of the date to fit your required format. The TEXT function is a great function to convert dates to different text formats. Method 1: Converting Date to Day of Week in Excel using the TEXT Function
