Welcome to the help center for Search Ads 360, a platform for managing search marketing campaigns.  While the help center is available to the public, access to the Search Ads 360 product is available only to subscribing customers who are signed in. To subscribe or find out more, contact our sales team.

weekday

Returns the day of the week (1 through 7) for the specified date. By default, the function starts counting on Sunday (1 = Sunday, 2 = Monday, and so on). For example, the function returns:

  • 1 for Sunday, January 1, 2012
  • 2 for Monday, December 31, 2012

Syntax

weekday(date, [week_start_day])

  • date can be any of the following:

    • Another function that returns a date.
    • A formula column that returns a date.
  • week_start_day (optional): A number indicating whether weeks start on Sunday or Monday. Valid values are:

    • 1: (default) Days are counted from Sunday. The value of Sunday is 1, and the value of Saturday is 7.
    • 2: Days are counted from Monday. The value of Monday is 1, and the value of Sunday is 7.

Examples

  • If today is Sunday, January 1, 2012 the following function returns 1:
    weekday(today())
  • If December 31, 2013 is a Tuesday, The following function returns 3:
    weekday(date(2013,12,31))
  • The following function returns 2:
    weekday(date(2013,12,31), 2)
  • If c:"specialDay" is a formula column that specifies Thursday, October 1, 2015, the following function returns 5:
    weekday(c:"specialDay")
Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
263
false