Skip to content
FormulaCraft

WEEKDAY

WEEKDAY returns which day of the week a date falls on, as a number. The second argument sets the scheme — type 2 makes Monday = 1 through Sunday = 7.

Excel
=WEEKDAY(A2, 2)
Google Sheets
=WEEKDAY(A2, 2)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2 is the date.
  2. 22 makes Monday = 1 through Sunday = 7.
  3. 3Wrap it in CHOOSE or TEXT to show the day name instead.

Need a version for your data?

Try: “Find what day of the week the date in A2 is, with Monday as 1”

Related

TODAY / DATEDIFEOMONTHNETWORKDAYS

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: