Databricks

This worked for me.SELECT  your_date_column,  CASE    WHEN DAYOFYEAR(your_date_column) <= 7 THEN 'Week 1'    ELSE 'Week ' || CAST(CEIL((DAYOFYEAR(your_date_column) - 7) / 7.0) + 1 AS STRING)  END AS WeekNumberFROM your_date_table;