Overview
Syntax | WEEKDATE(Year,Month,WeekOfMonth,DayOfWeek) | Returns the date corresponding to a specified day of a specified week in a specified month of a specified year. |
Parameter 1 | Year | Represents the specified year. |
Parameter 2 | Month | Represents the specified month. |
Parameter 3 | WeekOfMonth | Represents the specified week of the month. |
Parameter 4 | dayOfWeek | Returns the date corresponding to a specified day of a specified week in a specified month of a specified year. |
Notes
The extracted data supports four numeric or text parameters.
The real-time data supports four numeric parameters.
Example
Formula | Result | Note |
WEEKDATE(2009,10,2,1) | 2009-10-04 | Returns the date of the first day (Sunday) of the second week in October 2009. |
WEEKDATE(2009,12,1,-1) | 2009-12-05 | Returns the date of the last day (Saturday) of the first week in December 2009. |
