Explainry Tutorials to Expert in IT

WEEKDAY function in Google Sheets

The WEEKDAY function returns the day number of the week ranging from from 1 (Sunday) to 7 (Saturday) of the given date. For example, the function =WEEKDAY(“Jan 20 2020”) has the day number 2, which means it is Monday on that given date.

Syntax

WEEKDAY(date, [type])

date – Required. The date against which the day number is required.

[type] – Optional. 1 by default. The number indicating which number scheme to use for days of the week. Available options are:

  • 1 – Numbers 1 (Sunday) through 7 (Saturday).
  • 2 – Numbers 1 (Monday) through 7 (Sunday).
  • 3 – Numbers 1 (Tuesday) through 7 (Monday).

Examples




Copyright © 2016 - 2020 Explainry.com | All Rights Reserved