WEEKDATE- FineBI Document

Last update： 2022-04-04

1. Overview

Syntax	WEEKDATE(year,month,weekOfMonth,dayOfWeek)	Returns the specific day of the week in the specified week of the specified month.
Parameter1	year	Year
Parameter2	month	Month
Parameter3	weekOfMonth	The specified week of the month
Parameter4	dayOfWeek	Returns the specific day of the week in the specified week of the specified month.

Formula	Result	Remark
WEEKDATE(2009,10,2,1)	2009-10-04	The return date is the first day of the second week of October 2009.
WEEKDATE(2009,12,1,-1)	2009-12-05	The return date is the Saturday of the first week of December 2009.

中文（简体）中文（繁體）日本語

English