# 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 — 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 — 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