WDATE returns the end date of a week.
WDATE(Offset,Format,Not Used, WeekDef)
Offset: Sets the number of week groups from the start date of the report.
Format: The format that the date will be printed in. See here for format explanation.
Not Used: Set to 1 for function to work.
WeekDef: Defines the week. IE 7 is Sunday thru Saturday. Click here for a table defining weeks and the corresponding values for n. Returns results for any week regardless of the report dates. IE 7 with an offset of 53 would return Sunday thru Saturday for one year from the start date of the report even if the report date range is one month.
Function WDATE has been replaced by the GDATE function. It is documented here only for older reports that still use the WDATE function.
WDATE(2,"mm/dd/yy ddd",1,7) Shows the end date for the 2nd (Offset 2) Sunday to Saturday (Weekdef of 7) week.
Download Example Template: Help_WDATE.ss3 (Click here for download instructions)