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)

A2 = week starting on Monday; A3 = week starting on Sunday

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Convert weekday string to number in Excel

How to convert weekday strings to number in Excel?
Convert weekday string to number in Excel

CONVERT WEEKDAY STRING TO NUMBER — EXCEL FORMULA AND EXAMPLE

  1. =MATCH(A2,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0)

  2. =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

Convert weekday string to number in Google Sheets

How to convert weekday string to number in Google Sheets?
Convert weekday string to number in Google Sheets

CONVERT WEEKDAY STRING TO NUMBER — GOOGLE SHEETS FORMULA AND EXAMPLE

  1. =MATCH(A2,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0)

  2. =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