Added by Kurtis Cruzada, last edited by Thomas Morgner on Oct 30, 2007  (view change)

Labels:

Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.

Returns the day of week of a date, an integer between 1 and 7.

Syntax

Summary: Extract the day of the week from a date; if text, uses current locale to convert to a date.
Syntax: WEEKDAY( DateParam Date [ ; IntegerType = 1 ] )
Returns: Number
Constraints: None
Semantics: Returns the day of the week from a date, as a number from 0 through 7. The exact meaning depends on the value of Type:

  1. When Type is 1, Sunday is the first day of the week, with value 1; Saturday has value 7.
  2. When Type is 2, Monday is the first day of the week, with value 1; Sunday has value 7.
  3. When Type is 3, Monday is the first day of the week, with value 0; Sunday has value 6.
Day of Week Type=1 Result Type=2 Result Type=3 Result
Sunday 1 7 6
Monday 2 1 0
Tuesday 3 2 1
Wednesday 4 3 2
Thursday 5 4 3
Friday 6 5 4
Saturday 7 6 5

 

Examples

Syntax Result
=WEEKDAY(DATEVALUE("6/21/69")) 7
=WEEKDAY(DATE(1900,1,1),1) 7
BDate = "6/21/69"
 
=WEEKDAY([BDate],1) 		7