In Sheets, type the formula that returns the month number of the first order's date in cell F2.

Answer

=MONTH(F2)

Returns 1 for 2025-01-06. Works because the cell stores the serial 45663, not the text; on a text date it returns an error.