Documentation/How Tos/Calc: WEEKDAY function

From Apache OpenOffice Wiki
Jump to: navigation, search



WEEKDAY

Returns the day of the week for a given date.

Syntax:

WEEKDAY(date; type)

returns the day of the week that date falls on, as a number.
The number returned depends on type, as follows:
day of the week type=1 type=2 type=3
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
If type is omitted, it is assumed to be 1.

Example:

WEEKDAY("2008-06-14"; 1)

returns 7. 14Jun08 falls on a Saturday.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_WEEKDAY_function&oldid=243335"
Views
Personal tools
Navigation
Print/export
Tools