QuestionIn cell D2, return the order number, a space, a hyphen, a space, and the order date formatted as a full weekday name and date like 'dddd, mmmm d, yyyy' (e.g., 'ORD-77 - Friday, March 15, 2024').
How it’s written=TEXT(value, format_text)
Formats a number as text. Arguments in [brackets] are optional.
10 points for a first try without hints, 5 otherwise.