Instruction: Describe how you would use the TEXT function in Excel to format a date value '2023-01-01' to display as 'January 1, 2023'.
Context: This question tests the candidate's ability to use Excel's TEXT function to convert dates or numbers into a text string in a specific format. Candidates should demonstrate their understanding of function syntax and date formatting codes in Excel.
easy
easy
medium
medium
hard
hard
hard