Convert weekday string to number in Excel and Google Sheets
=MATCH(A2,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0)
=MATCH(A3,{"Sunday","Tuesday","Wednesday","Thursday","Friday","Saturday","Monday"},0)
=MATCH(A2,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0)
=MATCH(A3,{"Sunday","Tuesday","Wednesday","Thursday","Friday","Saturday","Monday"},0)
=MATCH(A2,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0)
=MATCH(A3,{"Sunday","Tuesday","Wednesday","Thursday","Friday","Saturday","Monday"},0)
A2 = week starting on Monday
A3 = week starting on Sunday
For a custom, start week change the day order in the curly bracket
=MATCH(A2,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0)
=MATCH(A3,{"Sunday","Tuesday","Wednesday","Thursday","Friday","Saturday","Monday"},0)
C2 = week starting on Monday
C3 = week starting on Sunday
For a custom, start week change the day order in the curly bracket